सर जी , एक प्रश्न है । मेरा मार्गदर्शन करें जैसे अटेंडेंस में घंटों को जैसे 08:30, 09:12 को हम कैसे इफ एंड का प्रयोग करेंगे । क्या इस फार्मूले का प्रयोग कर सकते हैं । यदि हां तो कैसे ?
Hi Sir, Excel File me Gender Ko Populate karvanve ke liye koi Formula hai kya on the basis of Age , Aur Agar Surname same ho to mobile number automatic populate ho , agar koi formula hai to batayiee sir
अगर if and फारमुलेसे या किसीभी फारमुलेसे सिर्फ particular month me present ya visit किया हो तो तो ✔या ✖ लाना हो तो कैसे लायें सिर्फ date के लिये. Cell मे date value hai pure November महीनेकी किसीभी दुसरे month की हो तो ✖ आना चाहिये और Nov. की हो तो ✔ आना चाहिये. ऐसा कुछ video बनाईये... मैंने आपकी बहुतसी video देखी है....
Sir kindly solve this equation... Count the total number of days you worked from home in the year due to the COVID-19 pandemic and multiply that by $2 per day. This amount will be your claim for the year (up to a maximum of $400 per individual in 2020 and $500 per individual in 2021 and in 2022). # of days you worked from home within the period (maximum 200 days for 2020 and 250 days for 2021 and for 2022) times by$2 (temporary flat rate amount) equals Amount of your claim (to a maximum of $400 in 2020 and $500 in 2021 and in 2022)
I need if n and function with date.. Means if date is less than 30-09-2019 than the value from this cell (figure) otherwise from this cell (figure) please suggest formula... Same if less than 31-03-2020....
Very beautiful video
बहोत बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद
Bhai aapne mera kam bahot asan kar diya hai
Nice Information. Thanks
Very gud..
If formula used excel # excellent, understand well, thnku for providing easiest method in if formula ""
Bahut achchhe se samajh me aa gya Apka bahut bahut dhanyvad
Thankyou sir
Very helpful video sir thanks
Thank you sir aapka video acha hai
Sir aapke sabhi video bahut achche hote hai thanks for nice information
Good ,,ना थके कभी पैर ना हिम्मत हारी है
हौसला है जिंदगी में कुछ कर दिखाने का
इसलिए लगातार सफ़र जारी है,,
💚💚❤❤🙏🏻🙏🏻💚❤💚❤
😊
WoW. SuperV. Dada Mujhe IF OR function ka video chahiye. Uska link dona .
SUPERB EXPLANATION. GOOD QUALITY OF VIDEO.
😊😊😊
Thnk u sir
Thanks sir, apne life par bhi ek video banao sir. I like ur video very much.
Dear Sir, i found Very valuable videos from your Channel
Thanks So Much
Bhot acha explain Kiya hai dost apne
Apke samjhane ka tarika gajab h 👍
Aapki es video se mujhe bhhut kuchh sikhne Ko Mila thankuuuuu...sir ji..
Love you your voice
SUPERB SIR
Thankyou very nice explanation, all got clear by viewing yr video.
very nice and full of knowledge
सर आपका video lecture great hai.
Fantastic
🤗
Nice
Very good
Thanku sir👌
THANKS SIR
Ap ke samjhane Ka tarika bahot achay hai
Sir ur super
thank sir, there were some issue with if & And. you clear it.
😊
Outstanding Explanation, Dear Deepak EduWorld.
Nice video
THANK YOU JI
Nice....before watching these video,i use nested if for checking pass fail,but ur way is easy for checking
Khub bhalo laglo Bro 😊
m ur big fan.. thx for helping us
Grace Mark
Super as always brother.great
Bhut theek video Sir
Thanks s lot for teaching,
Sir
It's very helpful video
Good night sir,
Thanks for your kind explanation.
thank you bro
nice sir
Vry gud vdo,thanks sir
Excellent Deepak sir...
It's very helpful..
now I got it how to use if & function
Thanks you Deepak bhai
Deepak sir please service now ka vedio banaiye.
very nice... keep it up
Deepak kumar vary nice video
Nested if or And function me kese pehchaan hogi condtion to dono me 1 se jyada hai
Sir this And function is Working As && Operator na . thanks sir sir Awesome explanation 👏👏👏
Excellent video
In this qn how to write a command to show the marks of any student by just writting a name in one cell and subject in another cell ?
nice
very good job
You are too good sir , but tally se related video bhi banai sir
Nice...
Thank you sir!!!
Sir kindly provide the link of if+or logical function
excellent vedio
Thank you sir.
Please make video on "OR" function
If formula se grade kaise nikalte hai sir Mai Apka hr Yek video dekhta hu aur uska note book bnata hu
Thank you
What is your contact no.
Please sir
Please also upload IF ERROR function video
I have published it.. Please visit our channel playlist ADVANCED EXCEL FORMULAS
Sir agar 40 se km valo KO 10 number bdhakr kaise denge
Salary sheet m and ka use kaise kre
Kaha rehte ho sir ? mor ka pyara sa voice sounds so nice
That sir
😊
Good video. Make a video about dollar sign in detail.
I have a excel sheet which calculate income tax ,make vedio how to make that type of excel sheet
Please service now ka vedio banaye. Please
Thanks Depak da
Real e Depak da upka pass sa hum bohot kuch sikhgiya.....
Thanks
Hi Sir,
Thanks for teaching us.
Mera paas ek question hai please help.
Kya Nested if aur And function ek hi hain, kya difference hai dono mai?
सर जी ,
एक प्रश्न है । मेरा मार्गदर्शन करें जैसे अटेंडेंस में घंटों को जैसे 08:30, 09:12 को हम कैसे इफ एंड का प्रयोग करेंगे । क्या इस फार्मूले का प्रयोग कर सकते हैं । यदि हां तो कैसे ?
G blkul.. Please wait i will publish video as soon as possible..
Hi Sir, Excel File me Gender Ko Populate karvanve ke liye koi Formula hai kya on the basis of Age , Aur Agar Surname same ho to mobile number automatic populate ho , agar koi formula hai to batayiee sir
right
lovly sir pls show "or" calculation
Nice..
Sir, How to use if and function for text, if value is true show negative amount, if false show positve amount.
Hello sir i want to learn vba programming, can you suggest me ???? Some tips
,nice
Plz send link if or logical function video??try to find but nothing find
result sheet mai jinke percentage 70 se jyada unko kaise find kare
iska formula hai kya
Us conditional formatting
Ap mera gurudeb ho
sir pls send the link of "if OR " video ...
very nice sir
Deepak sir logical test me multiple cell range select ho sakti hai kya
sir if and or in teeno function ka ek saath use batao
G
Agar Bhai Charo condition ki alag condion laganai h means kisi subject me 33 pass karna h kisi me 50 me pass karna h use kaise karege batoooo please
अगर if and फारमुलेसे या किसीभी फारमुलेसे सिर्फ particular month me present ya visit किया हो तो तो ✔या ✖ लाना हो तो कैसे लायें सिर्फ date के लिये. Cell मे date value hai pure November महीनेकी किसीभी दुसरे month की हो तो ✖ आना चाहिये और Nov. की हो तो ✔ आना चाहिये. ऐसा कुछ video बनाईये... मैंने आपकी बहुतसी video देखी है....
Please upload if, and ,or farmula.
Magar jo apne "and" function use kiya USS mai student 2 subjects mai pass hota hai aur 2 mai fail .what about 2 subjects.
And function Sabhi subjects ko valuate karega isiliye fail dikhayega.
Sir kindly solve this equation... Count the total number of days you worked from home in the year due to the COVID-19 pandemic and multiply that by $2 per day. This amount will be your claim for the year (up to a maximum of $400 per individual in 2020 and $500 per individual in 2021 and in 2022).
# of days you worked from home within the period (maximum 200 days for 2020 and 250 days for 2021 and for 2022)
times by$2 (temporary flat rate amount)
equals Amount of your claim (to a maximum of $400 in 2020 and $500 in 2021 and in 2022)
Sair me aapka har video apane copy par likhata hu ki bhavishya me kabhi bhi kam aayega
I need if n and function with date.. Means if date is less than 30-09-2019 than the value from this cell (figure) otherwise from this cell (figure) please suggest formula...
Same if less than 31-03-2020....
thank you sir परंतु यदि pass, fail और absent तीन value हो तो कोनसा farmula use करेंगे
Yahi lage ... Thoda sachange ho jayega