Bhai sahab wages ke column pe bhi formula use kar sakte the, =if(B2='Sunday',"500","450"). Yeh aur easy ho jata plus formulated bhi rehta instead of manual.
Ek batt sach hai bhai agar appko private company me job chahye to appke pass computer skill honi chahaye aur appki kam karneka tarika kesa hai wo bhi matter karta agar app short cut key use karke achha kam karogai to company ka boss impress ho jayega 👍👍👍👍
mene seekhna h mjhe complete kam sikhaa dein .. r yh btaa dein k yh seekh k mein ghr beth k fone sy yaha kam kr skti hu ? reply me must .. I m new here
Aap is channel par complete excel(basic to advance level) free me sikh skte h jo ki sabhi office me use hone wali ek common skill h. Offline aap apne nearest hospital, school, companies me bhi job krenge to apko excel aana bhot jruri h. 😊
Bhai questions to bhot sare hote h but, short video me (59 second) me ek question hi solve ho pata h Baki or jyada information ke liye aap long videos dekhe
Yes we can easily convert any image to excel. Simply search ,jpg to excel on Google and use any website then upload your image and click on convert The excel file will be downloaded
Uske liye aap day column me filter option use kre or pehle Sunday ko show krke 500 likh kr Ctrl+enter use kre Or fir other days ka Isse hajaro entry ka data 1 minute se km me type ho jayega
Sir main urban development vibhag me kam karta accountant ki post pe mujhe safai karmachariyon ka salry bana hota hai jisme 03 excel sheet hai aur mi chata hu jo data main sheet 1 pe type karu wo automatically sheet 3 pe update ho jaye kaisey kru help
Sir thanks for contacting with us and very unique question. iske liye aapko sheet 1 ke data ko other sheet me formula "=" use krke create Krna pdega uske bad AP agr sheet 1 me value change krnge to usse automatic sheet 2'3 me value change ho jayega
Bhai sahab wages ke column pe bhi formula use kar sakte the, =if(B2='Sunday',"500","450"). Yeh aur easy ho jata plus formulated bhi rehta instead of manual.
Great 👍
Me yahi likhne wala tha but apne already likh diya 😅
😊
B2 nhi C5
@@MHanda0601 Buddy, formula enter toh c5 pe hi hoga but kis cell pe if wala formula wo maine likha hai. Yeh toh bacche ko bhi pata hota hai.
This video can more then easy
Yes
amazing example sir
amazing
Thanks 😊
Amazing trick👍
Thanks 😊
Thanks Sir
🤗
thanks you sir
We
Ek batt sach hai bhai agar appko private company me job chahye to appke pass computer skill honi chahaye aur appki kam karneka tarika kesa hai wo bhi matter karta agar app short cut key use karke achha kam karogai to company ka boss impress ho jayega 👍👍👍👍
Right 👍
Its working 🤗
Thanks
bhut bdya
Thxs
Mera nahi aa raha hai
Aap Jese video me h vese shi se try kriye honjayega
computer formula lagana nhi ata kye kre sir is par video upload kro jald he 🫴
Aap konse formula ki bat kr rhe h......
@@DKTECH Excel ki
Aap basic se advance excel is channel par bilkul free me learn kar skte h.
Pura course available hai
Sath hi aapko chat support bhi milega
@@DKTECH par mare pas computer nhi kye kre sir pls answer 🫴
was a great but it can be more easy if we use IF formula
Yes every work has a multiple way to complete.
Thanks for your valuable feedback 🙂
Sir salary sheet aur employee attendance per ek video bnaye
ua-cam.com/video/5x3mWiQKctc/v-deo.html
Pl watch
sir if function lga kr wages bhi kr skte the jada easy hota
Yes, ek Kam ko hum alg-alg trike se kr skte h
Bhai wages me if function bhi to lga sakte hai
Yes 👍
Super
Thanks
Super tricks
Bhai isme type karna jaruri tha kya usme if formula nahi lga sakte the kya
Iske liye aap filter option use kre use apko kewal ek bar type krna pdega
Simple you can use nested if
If there lots of data
Without manually 👍
@@excelmaster1328 Great
mene seekhna h mjhe complete kam sikhaa dein .. r yh btaa dein k yh seekh k mein ghr beth k fone sy yaha kam kr skti hu ? reply me must .. I m new here
Aap is channel par complete excel(basic to advance level) free me sikh skte h jo ki sabhi office me use hone wali ek common skill h.
Offline aap apne nearest hospital, school, companies me bhi job krenge to apko excel aana bhot jruri h. 😊
@@DKTECH thnxx
Welcome 😊
Super tricks 🤣
Use if formula in wages 😊
Esme day name sunday ke samne 500 ne bijama 450 type karva ni su jarur hati...
D5 cell ma if formula lagadi devay...
=if(C5="Sunday", 500,450)
Speed thoda kam hai. Increase your speed.sothst every body can understand. Palthu
If ka formula sy aagy value b dal skta hy
=if(DAY="SUNDAY",500,450)
BHAI YE WAGES KA FORMULA HAI
👍
😊
Amazing trick of excel
Bhai ye formula kha se aaya ye batao kaha milege
Tmhare nanihal me ye formula milega😅😂😂😂😂😂😂
@@aaryamariya9676 backwash km ker or shi bata
Pls don't use this type joke
=if(Day name="sunday","500","450") ❤
Kya isme hum esa kar skte hai
F1 press karke custom me jakar general ko hata kar dddd type kare to kya same result a jayega ya ni
Nhi
Sir wages apne aap se sunday ko 500 ho jaye to kya kre agar bht bda data hoga to
Iske liye app ye trick use kre same :
ua-cam.com/users/shorts9no1Ty7aRik?feature=share
Or bhi informative trick ke liye hmare channel ke long videos watch kre or share kre
Bhai sikha to accha rahe ho
But 1 question ka interview kon leta he
Bhai questions to bhot sare hote h but, short video me (59 second) me ek question hi solve ho pata h
Baki or jyada information ke liye aap long videos dekhe
I have a 3 image can you say please how can i convat image to excel plz🙏🙏🙏
Yes we can easily convert any image to excel.
Simply search ,jpg to excel on Google and use any website then upload your image and click on convert
The excel file will be downloaded
online2pdf.com
online2pdf.com › ...
Convert JPG to EXCEL online & free
Sir your videos very useful..🥰🙏
Thanks 😊
If we have 365 days then is there any formula to seperate the amount of 500 and 450
It can be done through condition formatting
sir hum chahte to filter lagar k Monday select karke sab Monday par ek sath amount likh sakte h
Ha , smart trick 🤓
What is that meaning "dddd" four times you have given (why exactly 4)
dddd is a format which represents date/day name
sir advanced Excel ki salary kya e
Average 15 to 20 k
How to add 0 in excel plzz video
Pls explore your query..
@@DKTECH sir excel Mai 0 add nahi Hota remove hojata hai
आप थोड़ा और सीखो , प्रत्येक संडे में 500 लिखने की जरूरत नहीं है
Example- = If(c5="Sunday",500,400)
Okay 👍
yeh 4 bar d kiyn type kia?
Ye formula h isliye isme change nhi kr skte ho format h vhi use Krna pdta h
If function be like to me job chorh du 😂
use if formula instead
Ye thida long time hogaya
500 wages likhna
Button dabate hue keyboard bhi sath mein dikhave
Accha g
@@DKTECH or virtual keyboard ki png add karskte ho aap👍
Or ye png automatically screen pe aajayegi ek software aata hai use kar sakte ho
Thanks
sir agar data long hota to wo to likhta hi reh jata sir...
Uske liye aap day column me filter option use kre or pehle Sunday ko show krke 500 likh kr Ctrl+enter use kre
Or fir other days ka
Isse hajaro entry ka data 1 minute se km me type ho jayega
Sir main urban development vibhag me kam karta accountant ki post pe mujhe safai karmachariyon ka salry bana hota hai jisme 03 excel sheet hai aur mi chata hu jo data main sheet 1 pe type karu wo automatically sheet 3 pe update ho jaye kaisey kru help
Sir thanks for contacting with us and very unique question.
iske liye aapko sheet 1 ke data ko other sheet me formula "=" use krke create Krna pdega uske bad AP agr sheet 1 me value change krnge to usse automatic sheet 2'3 me value change ho jayega
ua-cam.com/video/3dxUCpVk7Wk/v-deo.html
Ye video se shyad apka issue solve ho jayega agr fir bhi koi query hoto comment kre
@@DKTECH sir sheet 1 ka data = krke sheet 3 pe krte h to 0 aata h
Sir reply please
Pls share your excel file and screenshot on email for better understanding 'kumardineshnp@gmail.com
who is told you brother, use this formula is that Candid also rejected, your video is nor fully perfect
Dates toh dekho 😂😂
Date me kya hua
Kya hai ye bhai 😂😂😂 long data hoga fir to if use krna padega 😮
Yes, is video me normally day name count Krna btaya h 😊
Mene Jo date ka formula lagaya usme same date me Sunday aa rha or apke date me alag day aa rha
day to same hi aana chahiye
Aap kis date ki bat kr rhe h
Sir date idhar udhar aya
Shi aya hoga bs date me mahina ya date aage piche ho gai hogi jese
DD/mm/yy ya mm/DD/yy
Huh?
Worng ha
How ?
Reject ho jayega apka subscriber
Why