IF function Excel | Nested IF function in Excel

[@ExcelSuperstar]

Get 100% OFF on Excel Interview Essentials course *Use Coupon Code - ESSJUL20* Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ

[@ravigupta2609]

Dear Sir Mera Nam Ravi Kant Gupta Hai mene aaj tak bahut se excel video dekhe hai par aaj pahli bar aapke video dekhe jo mujhe bahut pasand aaye aap ki batane ka tarika mujhe kafi pasand aaya bahut bahut shandar aapke sare video mujhe kafi pasand aaye dhanyabad Mr Rishav Ji

[@manik363]

Sir You explain complicated stuff in much more easy and in understable way. Thanks

[@nitinladke2448]

Your best teaching methods. Anybody can understand easily the way you explained video.

[@bablukhanblh6847]

Hm abi aap k nae student bane h Aap k batane ka tareeqa bahut hi pyara hai.shukriya

[@bikramjha3947]

Its good to see after long time, you have taught us costing at edjonex coaching classes

[@sureshnagwan7805]

Very simple way of teaching 👍

[@ManojSingh-xw7yc]

Very Nice Sir and your all video Explain is very good thanks for share.

[@sahu1991]

Thankyou so much sir aap bahut hi achha samjhate ho

[@deveshnegi8753]

Too easy and precise.. any tutorials on ms word?

[@pihoopihoo3225]

BHut achha sikhate h sir AAP mujhe y if smj m hi nhi aaya tha BT ab AA gya

[@poojamaurya3043]

your teaching style is nice

[@abhishekrathi4839]

God bless you People like You help to became more smarter

[@vinuji2403]

Kya baat kya baat kya baat Sirji kya explain karte ho.

[@Jyoti-lb1zd]

Super Sir.. Kitni easy method se samjhaya apne

[@wrongturnlima007]

Very simple and useful...the best 👍

[@babarqureshi5043]

Thanks sir. Kindly make video if with conditional formatting.

[@Deepsingh-1313]

aap such mai excel superstar ho sir

[@ravishankersharma666]

sir, mere pass ek table h us per me if ka formula lgana chahta hu pls advice me ..table kese post kru ....

[@SATENDRAKUMAR-ew9mr]

Very Nice All Your Video I am very happy

[@rajeshbhartimpbharti4239]

thank you superstar ji aap ka vedio mujhe bahot accha laga

[@saquibsher]

Great ! But I have a question that in second IF u put two conditions then why the same format doesn't work with first IF Condition.

[@arinarin8702]

How many if can use in this function.?? I want use 10 if condition. Is that possible?

[@javariatariq61]

Where I could find your workbooks

[@learningpointdestination5401]

Very nice ........Impru Ur Knowledge...to See this Excel Video or Bane Excel Superstar..

[@poonamkaushik3574]

wah ! Sir superb style of teaching

[@ExcelSuperstar]

Advanced Excel Webinar v2.0 Hurry up! Book your seats now(limited seats) www.excelsuperstar.org/

[@DhiruJi02]

Kamal.ke teacher ho sir ji..

[@dharmendrayadav-bw2gp]

Nice video sir. Sir how to make culculation between two sheet if we want all culculation result show on another sheet.

[@pritombaruah5393]

Hi Rishabh, I'd like to sort cells where CASH DEPOSITED is there....

[@nadeemahmad7155]

Sir, How to automatically change student photo with their student id number when student photo store in other folder? Plz help me.

[@mehaq786]

Nice video plz make vedio on this situation "if I have 1 target workbook which is automatically updated from other workbook. in the target workbook sheet cell I want to display date on which that cell was modified from source workbook sheet .thanx

[@shaifalikalia6848]

Awsome and easy way to teach.thank u so much.

[@mnhiba3532]

Hi Friend, Please help me in my query, i have a table that i want a formula to tell me if its a Bale, Bag, Meter or Carton when i type on each column like Shoes, Purses... etc. is it possible... How can i send you an example table ? Thanks.

[@excelera2811]

Very Nice Video Keep Doing Good Work Sir

[@rupeshpandya9590]

Great knowledge, 👌👌👌👌

[@noorenabihawari8378]

hello sir, is't possible to highlight the cell by comparing two parrameters by using "if" if yes how pls help us by ur tutorial........

[@SuperSyed12]

Very well explained

[@hirakantbudhe4171]

Your the best teacher and explain easy technica. Thank you.

[@anujchauhan3013]

Sir plz solve my broblem i have contains Dr and Cr default at end of balance in column export from tally and i wants to sum Dr and Cr saperately .

[@ajaykumar-fo5hv]

Thank you sir, your video is very helpful. Sir I want to add some video about Auto sort

[@askhan67]

Thanks man you saved my time

[@altafamirali4946]

Hi sir ma ap ki excel tutorials se buhut kouch seka hae. pls let me know agar 3 columns hon tu logic kis tarah lage ga pls help me

[@skexcelexpert8021]

Nice video sir

[@umeshchaudhari1860]

I need help with a Nested IF formula. If Date1 = Date1 + 7 days and Date2 is Blank, then "Return Window Closed", If Date1 < Date1 + 7 days and Date2 is Blank, then "Awaiting Return" if Date2 is not Blank then "Return Received". If Date1 and Date2 is Blank then show nothing on the cell.

[@ಕಲಿಯಿರಿಕಲಿಸಿರಿ-ಯ7ಜ]

Sir mai ek summary banana cha raha hu ki ek state me 4 district hai usme mahila aur bachche kaa list yaani nominal roll banadiya lekin summary me nahi kar paaraha hu kyoki kounsi formula lagana hai vo clear nahi horaha hai please help me

[@RAJINDERSINGH-xx4or]

I want that when I fill column "c" only then column "a" is filled automatically with today().how to get date automatically filled in column a. Problem is that today() is updated automatically after the day is over.

[@rambdrchand6354]

Thanks a lot for this video & it was big help, i'm a civil Eng. by profession, could you please send more videos attaching if, and ore

[@tejraj58]

sir dono cell mein minus minus hai to usme plus 10 ki formula kaise lagau. pl bata do

[@deependersingh3332]

But Sourabh Ji, Main ek sheet me ulajh gya hun pls help me. Actually Company software se data (excel) sheet me kuch figures kuch esi hoti hain(A645FG5TY9). ab isme jo left se pahale letter ke mutabik kuch bhi likhna ho to kaise likhenge?

[@darknight8507]

Love from Lahore, Pakistan

[@svs7748]

when to use if + if formula instead of nested if

[@kr.laxman]

Sir..I want to count and calculate Halfday (H=0.5) in attendance sheet is it possible..???

[@bikramjha3947]

Nice video it was

[@chhayachadha2136]

Nice video 👍🏻

[@sandhyagupta7195]

Thanks a lot this is really very helpful for me

[@thedits4614]

IS IT RIGHT THAT IN IF THERE IS A LOGICAL TEST BUT IN NESTED IF THERE IS MORE LOGICAL TEST

[@vikashkumarsingh6226]

Sir, I have a question? In a column name from party name and one word is same some party and I want if same word coming then show transfer and other show purchase. How can i do it.

[@amitdas-ug7yl]

Is nested if work on number Example: =if(A1>1,1, if(A1>30,2,0))

[@arpitporwal8676]

Very good

[@ticpyc4166]

the best teacher

[@pakistanbesttv8663]

Hi Excel super 🌟 koi tareqa batain k employee ki retirement Date Jo baqi rati hai years,month,days main show ho otherwise likha aye retired plz reply thanks.

[@gajanandhumal8883]

Thank you bro..you helped me a lot

[@satyajay8276]

Kya samjhaila he bhaaaiiiiiiiiiiiiiiiiii...............................! ;) :)

[@gabbar5612]

Thanks

[@passion8040]

For multiple "IF" function we can use latest "IFS" function also.......

[@Andy__9]

For 2019 version

[@thisarashanuka]

Hi Guys, please visit below link to view Awesome Nested If video kzbin.info/www/bejne/oZvdZYlrpdR1ndk

[@arunrai2909]

Very informative and interesting...kya smjayela h boss...

[@subhaspaul8776]

bggggh

[@subhaspaul8776]

bhh

[@zeyadzeyad6950]

What is if funtion definition

[@harishprasad639]

You are awesome

[@anuragbishwokarma5825]

i need ur help more for this pblm for example: cost of first 20 items rs 4/ item and more than 20 item it cost 9/item. (25item=20*4+5*9 =80+45 =125) for thi case plz help me to find this.

[@bongkobi8710]

Thik se bataiyega ap kya problem face kar rahe ho...

[@VikramSingh-uo8jp]

very nice

[@110ZRIZVI]

explAINED WELL

[@abhishekpathak9559]

How can I solve this question If student’s average is 90 or greater, they receive an “A” between 80 and 90 is a “B” between 70 and 80 is a “c” other “F”.

[@bongkobi8710]

=if(cell>=90,"a",if(cell>=80,"b",if(cell>=70,"c","fail")))

[@vikashkumarsingh6226]

Sir, Namaste.

[@shai347355]

Really Great

[@josephkarottu4166]

Sir, Good narration. could you help me with an excel formula. My designation now & until 02-07-2022 is "Assistant accountant" , and from 03/07/2022 to 02.07.2027 should be "Accountant" & from 03.07.2027 it should be "Senior Accountant"

[@pakistanbesttv8663]

Bahi sb koi tareqa batain employee k retirement duration agr retired ho jay tu duration ki jaga retired likhna aye

[@Massmjmc]

Awsome!👌

[@begnasonline8299]

superb

[@deependersingh3332]

Thank You

[@Anju-bv1ul09]

Hi thanks a lot this is really very helpful Plz also add some macro and nested if functions Thanks keep Gud work

[@ExcelSuperstar]

Watch this video on nested if kzbin.info/www/bejne/iF7GlqatmtGip6M Macro videos are here kzbin.info/aero/PLnVcHd3TXd2oqfnbuiFV9pc_HsV9tWw4K

[@kohinoorfilms9121]

good

[@Natures_lover848]

Reply this link

[@dipakkumarlahre6672]

Gjb sir

[@dr.arunchaudhari4393]

I have list of Fruits in column A nd their price in column B, The list is endless How to I use if function for this endless list?

[@aamcadmin5691]

Sir Jahan age he nai likhe ho tu wahan blank kse show hoga

[@sameelafaqkhan274]

error formula k through

[@AB-ex8ck]

TYSM Sir

[@dilipshedge8503]

Thanks you Sir

[@girlwith_luv]

Why this does not work =IF(G9>=18,"ADULT","MINOR",IF(G9>=60,"SR CITIZEN"))

[@ankursharma6157]

This should help: =IF(G9>=60,"SR CITIZEN",IF(G9>=18,"ADULT","MINOR"))

[@arijeetkumarsharma226]

Awesome

[@mannantravel9332]

0-2=infant / 2-12=child / 12-60=adult / 60> up=sr sitizen ??? formula pls?

[@kanhaiyasingour5860]

=IF(AGE CELL>60" SR.CITIZEN ",IF(AGE CELL>12" ADULT",IF(AGE CELL>2" CHILD","INFANT")))

[@RohitYadavIND]

Plz exp IF AND SUM

[@pothree5318]

Yes.good.thanks

[@satyampandit768]

Bhai 1 sath 8 IF ka use kese hoga wo btao

[@Anujkumar-sh3ph]

Hello My Dear si Mera Name Anuj kumar Hai Aap Ms. Word Main Refrence tab ki ki full video uplode jisme khaskar mujhe index banae men problme aati hai

[@ExcelSuperstar]

Word trick ke videos kzbin.info/aero/PLnVcHd3TXd2r3J4qNqHO9tFpZV60Iy8i8

[@mahendrapratapsingh9205]

can we extract a Full Name to separate column or row for each letter by formula?

[@altafamirali4946]

Hi excel dost, muje ek logic lagani hae office k kaam k leye but problum ho rahae pls ap apna email id share karain tu ma excel ki file example k leye ap se share kr sakon pls solve my problum. regards.

[@bongkobi8710]

Altaf Sachwani [e-mail]

[@chandanmajhi225]

helpful

[@bobykumar9631]

VERY NICE VOICE.. WHY DON'T YOU TRY FM

[@travelingwithankush5777]

nice

[@snehatiwari2807]

How to make a mark sheet if students are absent in some exams using excel

[@bongkobi8710]

Sneha tiwari PLEASE apna data show kijiye.. Fir me apko tarika bataunga.

[@mwaqasvirk489]

Boht khooob