IF function Excel | Nested IF function in Excel
Вставка
- Опубліковано 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
Kya baat kya baat kya baat
Sirji kya explain karte ho.
Thankyou so much sir aap bahut hi achha samjhate ho
God bless you
People like You help to became more smarter
wah ! Sir superb style of teaching
Super Sir.. Kitni easy method se samjhaya apne
Advanced Excel Webinar v2.0
Hurry up!
Book your seats now(limited seats)
www.excelsuperstar.org/
aap such mai excel superstar ho sir
the best teacher
thank you superstar ji aap ka vedio mujhe bahot accha laga
Thanks man you saved my time
Very simple and useful...the best 👍
Kamal.ke teacher ho sir ji..
Awsome and easy way to teach.thank u so much.
Very nice ........Impru Ur Knowledge...to See this Excel Video or Bane Excel Superstar..
Thank you bro..you helped me a lot
Thanks a lot this is really very helpful for me
Very simple way of teaching 👍
Great knowledge, 👌👌👌👌
Thank you sir, your video is very helpful. Sir I want to add some video about Auto sort
Really Great
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
Your the best teacher and explain easy technica. Thank you.
Very well explained
Hm abi aap k nae student bane h
Aap k batane ka tareeqa bahut hi pyara hai.shukriya
Kya samjhaila he bhaaaiiiiiiiiiiiiiiiiii...............................! ;) :)
Thanks sir. Kindly make video if with conditional formatting.
your teaching style is nice
Very Nice Sir and your all video Explain is very good thanks for share.
BHut achha sikhate h sir AAP mujhe y if smj m hi nhi aaya tha BT ab AA gya
Very Nice Video Keep Doing Good Work Sir
Very Nice
All Your Video
I am very happy
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
Thanks you Sir
Thankq so much sir
Awsome!👌
Nice video 👍🏻
Nice video sir
Thank You
explAINED WELL
Thanks Sir
superb
Nice video it was
TYSM Sir
Love from Lahore, Pakistan
Yes.good.thanks
Very good
Gjb sir
Thanks
Too easy and precise.. any tutorials on ms word?
very nice
Sir, Namaste.
helpful
You are awesome
Awesome
Boht khooob
nice
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
Nice video sir. Sir how to make culculation between two sheet if we want all culculation result show on another sheet.
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.
Very informative and interesting...kya smjayela h boss...
bggggh
bhh
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 ua-cam.com/video/R-cesweloqA/v-deo.html
Macro videos are here ua-cam.com/play/PLnVcHd3TXd2oqfnbuiFV9pc_HsV9tWw4K.html
good
Reply this link
Sir,
How to automatically change student photo with their student id number when student photo store in other folder?
Plz help me.
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.
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, mere pass ek table h us per me if ka formula lgana chahta hu pls advice me ..table kese post kru ....
IS IT RIGHT THAT IN IF THERE IS A LOGICAL TEST BUT IN NESTED IF THERE IS MORE LOGICAL TEST
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 .
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........
Hi Rishabh, I'd like to sort cells where CASH DEPOSITED is there....
Sir..I want to count and calculate Halfday (H=0.5) in attendance sheet is it possible..???
when to use if + if formula instead of nested if
Plz exp IF AND SUM
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.
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.
sir dono cell mein minus minus hai to usme plus 10 ki formula kaise lagau. pl bata do
Where I could find your workbooks
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?
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
ua-cam.com/video/kjz4V5poBgw/v-deo.html
How many if can use in this function.?? I want use 10 if condition. Is that possible?
Is nested if work on number
Example: =if(A1>1,1, if(A1>30,2,0))
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.
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"
What is if funtion definition
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.
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
Bahi sb koi tareqa batain employee k retirement duration agr retired ho jay tu duration ki jaga retired likhna aye
Bhai 1 sath 8 IF ka use kese hoga wo btao
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...
VERY NICE VOICE.. WHY DON'T YOU TRY FM
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")))
can we extract a Full Name to separate column or row for each letter by formula?
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.
Sir
Jahan age he nai likhe ho tu wahan blank kse show hoga
error formula k through
Palak paneer
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
Word trick ke videos ua-cam.com/play/PLnVcHd3TXd2r3J4qNqHO9tFpZV60Iy8i8.html