Mastering The IF Formula in Microsoft Excel (10 Examples) - IF Formula in excel | Excel IF Function 

If the value is 1 to 60 then 1, if value is 61 to 120 then 2, if value is 121 to 220 (for 100 numbers) then 3 and continue....4,5,6... Then what is the if formula...?

Pdf provided by yours is very very helpful and your teaching style is also ausm ❤

Ex 9 ka formula =if(min(c3:c5)>=40,"pass","fail")

Hello sir ,y formula to apply ho jata h but jb hm original list delete krte h to jaha formula apply krk mr,miss add kiya h wo b delete ho jati h uske liye kya kre pls reply sir

कृपया गुरुजी परीक्षा मे बैठक व्यवस्था हेतु एक्सेल शीट कैसे बनाएंगे बताने की कृपा कीजिये। Respected sir kindly make and advance exams seating pattern in Excel in which when we will and start insert the number of students in a row then roll number automatically shift into the another line.

I am placing/writing a formula in cell C1 In A1 - Its EXPIRY DATE In B1 - Its RENEWAL DATE =IF(TODAY()>=B1,"SEND RENEW REMINDER","WAIT") The above formula is working. Now, I want to apply one more condition in same cell C1 - That if A1 is less than TODAY's date, the result should be "PENDING" and if I write manually (CANCELLED) in A1, the result should be "CANCELLED". Something like =IF(TODAY()

Sar ek per day collection Lene wali seat banaaiye jismein with penalty daily payment receive kar sake 6 mahine se lekar 1 sal 2 sal 3 sal Tak

Sir ek question hai Meri company me 10 employee hai jisme mene unko target diya hai agar vo 5 lakh se jyada sales karte hai to me unko 5 lakh pe 0.5% incentive duga or agar vo 10 lakh se jyada sales karte hai to me unhe 10 lakh ki amount pe 1% incentive duga to me use Excel me kese formula lagake pata karu ki kisko kitna incentive milega or muje 1 hi row line me jankari chahiye ???

Win +. For symbol, learned something new

Sir ji your videos are very useful for us the teachers in many ways like attendance sheet, result sheet, MDM calculations etc. Thanks 🙏🙏 Suresh Ram ETT teacher Government Elementary Smart School Sassi Brahmna cluster Bibipur Block Samana, Patiala Punjab India

Sir And wala Thora hard laga

Deepak bhai please ek series start karo jisme hum Ai ki help se excel use kare

I have a question regarding application of formula/function. My question is, how is it possible to create a sheet with VBA using the formula I am using in any cell of Excell? For example, in cell A2 I want to print the present age of a person, for that I have to use a formula in that cell, but that formula I want to use in VBA. How to write the formula in VBA?

2 sheet mei agar 1 value jo sheet 1 mei Column A mei kahi bhi hai to True and nhi hai to false. chahe Sheet 1 ke cell A2 wali value Sheet 2 ke A31 cell mei hai to bhi true or poore A column mei nhi h to false. ye kaise banega formula

deepak sir exel vba cheak box par video banaye

Nice video Plz upload subtotal video

PLEAES RESOLVE BY IF FORMULA ID DATE RESULT 1001 25-08-2024 1 1001 26-08-2024 2 1001 27-08-2024 3 1001 28-08-2024 4 1002 29-08-2024 1 1002 30-08-2024 2 1003 31-08-2024 1 1003 01-09-2024 2 1003 02-09-2024 3 PL SUGEST "IF" FORMULA FOR RESULT AS 3rd column

Sir aap say request hai yak bank statement ka PDF file ka yak video banaye jismi sumif, filter ka use karke bataye

Sir , kya eise kuchh formula hai jise hum el number ki bich wala zero ko hata sakte hai . Example - ek cell me hum 531096 likhe and formula laga hua cell me 53196 show ho .

Have u any online paid or free course... I want to basic to advance excel

Hi brother Ek video banavo jisme Photographer booking, price, count automatically show kare kitna bookings huva, kitna payment aya kitna baki hai

दिपक जी नमस्कार, मैं नागपूर, महाराष्ट्र का रहिवासी हूं मूझे बताओ की एक्सेल शीट मे प्रेझेंट , अबसेंट और हाप डे वाले एम्प्लॉइज को कैसे ढूंडनआ उसके लिये फॉर्म्युला बताओ.

Bhai Mujhe time me lagana but logic hai in out print ho

marksheet mei agar condition ho ke 2 subject mein passing marks se kam ho to compartment lika aaye , aur 3 ya isse jada wala fail to ye kaise hoga? pls reply.

Deepak Sir, you are. awesome ❤❤

Very informative especially if and formula. Thnx

Ak baar me hi samajh me aa jaye kuch aisa tha experience 🙋 thanks keep teaching

"The specified formula cannot be entered because its uses more than 64 levels of nesting" ko resolve kr sakte h kya

You have good psce of teaching(explaining).Friendly to understand.Assents comfortable to understand ,Good going.My personal thanks👌👍

One of the best channel on RU-vid ❤

दीपक सर मै आपसे निवेदन करत हॅू कि ( हिन्‍दी ) में ए‍क Drop डाउन लिस्‍ट बना दीजिए । ईगलिश मे जो आप Drop डाउन लिस्‍ट का विडियो बनाकर अपलोड कियें थे सर जब वो Word Delate करते है सर Drop down list से भी हट जाता हैं । ये जानकारी मुझे अभी तक किसी भी यूटूब चैनल पर नही है । एक बार हिन्दी मे ड़ॉप डाउन लिस्‍ट बनाकर सही से explain कर दिजीए सर ।

for special paste use alt+ctrl+v

DEEPAK SIR YOUR TEACHING IS VERY GOOD

Mast video 👌Aise or bhi formula ke videos banao sir

Please provide link of the practice file in the description

Video Bahu Achcha Laga Sir.

how put * sign in marksobtained of student less than 30 if marks is already fill up in the cill

very good. 👍️👍️👍️👍️🇳🇵🇳🇵🇳🇵

Best tutor ... Providing practice file also.. Thank you so much sir.

nice video sirji ...apka koi excel ka advance paid course hai to bata dena ji...

How to calculate 20% increase for broken year or period? For example 3minths, 7 months 11 months. In short less than one year period.

gvyjmnyxft

Valuable information for me, thanks a lot,

Wonderful Sir 👍❣️

Thank You So Much

Thank you so much sir

Very good teaching brother

RU-vid pr best chenal brother ❤

Thank u so much sir

सचमे बढिया विडिओ सर 👌👌

You are pass

Super'b

Awesome sirjee... It was nice feeling to watch your video

Thanks you sir.

U r best

Super

bahut hi beautiful videos

Thxx uhh sir 🙏

Thanks a lot,!!! Subscribed!!!

So good

Ms office 2013 pe kaam kre ga formula sir

LOVE FOR YOU SIR YOU ARE KING OF EXCEL(I AM FROM PAK )

❤ Best Tutor on RU-vid...

Thank you so much sir

❤loving your videos

Thank you sir ji

Thanks

thanks alot

Wow🎉🎉🎉🎉🎉

Very good video

lajawab videos

Bhai kyu seekhe kya karege seekh ke batao aap seekhetae raho hum bhulte rahe hai..... Naukri to hai nahi