IF function Excel | Nested IF function in Excel
HTML-код
- Опубликовано: 15 май 2016
- IF Function:-
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. In its simplest form, the IF function says:
IF(Something is True, then do something, otherwise do something else)
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False
Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
Nested IF Function:-
Using a function as one of the arguments in a formula that uses a function is called nesting, and we’ll refer to that function as a nested function. For example, by nesting the AVERAGE and SUM function in the arguments of the IF function, the following formula sums a set of numbers (G2:G5) only if the average of another set of numbers (F2:F5) is greater than 50. Otherwise, it returns 0.
Get 100% OFF on Excel Interview Essentials course Use Coupon Code - ESSJUL20
Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
IF function and Nested IF function in Excel
#IFfunction #nestedIFfunction #NestedIF #excelinhindi #advancedexcel #excellogicalfunction
excel if function text
excel if function multiple conditions
multiple if statements in excel
excel if statement multiple conditions range
how to insert an if function in excel
countif function in excel
excel if contains
ifs function excel
excel if contains partial text
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course Pen drive visit: www.excelsuperstar.org/excel-...
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar
Get 100% OFF on Excel Interview Essentials course *Use Coupon Code - ESSJUL20*
Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
Your best teaching methods. Anybody can understand easily the way you explained video.
Its good to see after long time, you have taught us costing at edjonex coaching classes
Sir You explain complicated stuff in much more easy and in understable way.
Thanks
God bless you
People like You help to became more smarter
Advanced Excel Webinar v2.0
Hurry up!
Book your seats now(limited seats)
www.excelsuperstar.org/
Kya baat kya baat kya baat
Sirji kya explain karte ho.
Super Sir.. Kitni easy method se samjhaya apne
Thankyou so much sir aap bahut hi achha samjhate ho
Kamal.ke teacher ho sir ji..
thank you superstar ji aap ka vedio mujhe bahot accha laga
wah ! Sir superb style of teaching
aap such mai excel superstar ho sir
Thank you sir, your video is very helpful. Sir I want to add some video about Auto sort
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
Thanks sir. Kindly make video if with conditional formatting.
Very nice ........Impru Ur Knowledge...to See this Excel Video or Bane Excel Superstar..
Very simple and useful...the best 👍
Awsome and easy way to teach.thank u so much.
Very simple way of teaching 👍
Your the best teacher and explain easy technica. Thank you.
Hm abi aap k nae student bane h
Aap k batane ka tareeqa bahut hi pyara hai.shukriya
the best teacher
Thanks a lot this is really very helpful for me
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
Thank you bro..you helped me a lot
Really Great
Great knowledge, 👌👌👌👌
Thankq so much sir
Very Nice Sir and your all video Explain is very good thanks for share.
Thanks
Thanks man you saved my time
Thank You
Very well explained
Thanks you Sir
Very Nice
All Your Video
I am very happy
Thanks Sir
Too easy and precise.. any tutorials on ms word?
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.
TYSM Sir
Kya samjhaila he bhaaaiiiiiiiiiiiiiiiiii...............................! ;) :)
Yes.good.thanks
Gjb sir
Awsome!👌
your teaching style is nice
BHut achha sikhate h sir AAP mujhe y if smj m hi nhi aaya tha BT ab AA gya
Nice video it was
Very Nice Video Keep Doing Good Work Sir
You are awesome
Nice video 👍🏻
superb
Very good
Nice video sir
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
Sir, Namaste.
very nice
Nice video sir. Sir how to make culculation between two sheet if we want all culculation result show on another sheet.
helpful
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.
Awesome
explAINED WELL
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
Sir,
How to automatically change student photo with their student id number when student photo store in other folder?
Plz help me.
sir, mere pass ek table h us per me if ka formula lgana chahta hu pls advice me ..table kese post kru ....
Love from Lahore, Pakistan
nice
Sir..I want to count and calculate Halfday (H=0.5) in attendance sheet is it possible..???
Boht khooob
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........
sir dono cell mein minus minus hai to usme plus 10 ki formula kaise lagau. pl bata do
Hi Rishabh, I'd like to sort cells where CASH DEPOSITED is there....
Where I could find your workbooks
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 .
Hi thanks a lot this is really very helpful Plz also add some macro and nested if functions Thanks keep Gud work
Watch this video on nested if ruclips.net/video/R-cesweloqA/видео.html
Macro videos are here ruclips.net/p/PLnVcHd3TXd2oqfnbuiFV9pc_HsV9tWw4K
good
Reply this link
IS IT RIGHT THAT IN IF THERE IS A LOGICAL TEST BUT IN NESTED IF THERE IS MORE LOGICAL TEST
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.
Very informative and interesting...kya smjayela h boss...
bggggh
bhh
when to use if + if formula instead of nested if
How many if can use in this function.?? I want use 10 if condition. Is that possible?
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.
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?
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
What is if funtion definition
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.
Plz exp IF AND SUM
Bhai 1 sath 8 IF ka use kese hoga wo btao
For multiple "IF" function we can use latest "IFS" function also.......
For 2019 version
Hi Guys, please visit below link to view Awesome Nested If video
ruclips.net/video/kjz4V5poBgw/видео.html
Bahi sb koi tareqa batain employee k retirement duration agr retired ho jay tu duration ki jaga retired likhna aye
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?
Is nested if work on number
Example: =if(A1>1,1, if(A1>30,2,0))
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"
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.
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.
Thik se bataiyega ap kya problem face kar rahe ho...
Sir
Jahan age he nai likhe ho tu wahan blank kse show hoga
error formula k through
can we extract a Full Name to separate column or row for each letter by formula?
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”.
=if(cell>=90,"a",if(cell>=80,"b",if(cell>=70,"c","fail")))
Palak paneer
VERY NICE VOICE.. WHY DON'T YOU TRY FM
How to make a mark sheet if students are absent in some exams using excel
Sneha tiwari PLEASE apna data show kijiye.. Fir me apko tarika bataunga.
Soha sohail naa