This is the most comprehensive NESTED IF lesson ive found here on youtube imo. Cheers!
@rsrawat1947
8 жыл бұрын
Thanks. I was looking for this tip. Now my Worksheet for calculating Additional Pension for ages above 80, 85, 90, 95 & 100 is done -thanks to you. I am 79 yrs old.
@victorgibaopauljohnny5347
Жыл бұрын
this is very helpful. I have labored all day trying to fix the IF Nested function. This is just sweet
@raindropsofsky
Жыл бұрын
Using nested if function for calculating marks of the students is no more difficult after I watch this video. Thank you for uploading this video.
@sssmi3
3 жыл бұрын
You've helped me more than my teacher did in two years
@Noc4ball
7 жыл бұрын
Thank you so much for this. This is exactly what I was trying to accomplish with a vacation spreadsheet I am putting together for work based on years of service.
@rosarioramirez4776
4 ай бұрын
you are amazing thank you so much I understood this way better than my course example!
@moinulislam9685
4 жыл бұрын
Excellent explanation! As a teacher and a few new head of department this was exactly what I needed to know to create our internal tracking system.
@JimFikes
4 жыл бұрын
Thank you. If you ever come across something you need from Excel, send me a request and I'll be happy to produce a video for you.
@islambadr4213
8 жыл бұрын
Finally I am able and understand what I was planning to do, after searching a lot of KZitem, thank you so much.
@revikaverma1765
6 жыл бұрын
Islam Badr 1x\aa\
@tejuB2006
2 жыл бұрын
I have seen so many videos on nested if and no one explained me this clear !
@brookel3920
8 жыл бұрын
Thank you!!! I was finally able to finish my homework thanks to this video 😊
@framemaxxer
4 жыл бұрын
THANK YOU SIR! i had to use excel to compute some data for markov chains... and finally found out about if statement equation thingy... really like what would i do without you! much love, thank you Mr Fikes
@gordospeti
7 ай бұрын
Newer versions of Excel will require that semicolons rather than commas be used. Thanx for the explanation Jim, you have helped me a lot!
@DTOM76
2 жыл бұрын
Thanks! I searched the tube a long time, finally you showed me exactly what I was looking for!
@learn3045
Жыл бұрын
Tomorrow is my lab examination based on excel, and I am saved just by watching your excellent video. You really deserve more million subscribers sir. I Really appreciate your hard work and determination to quality content. Yours Truly, Raiyan Khan.
@mangu768
2 жыл бұрын
You SIR! are a gentleman and a scholar.. Thank you
@antoniofdz09
8 жыл бұрын
HEY, thank you so much! This helped me complete my homework for tonight.
@prismaprisma6079
2 жыл бұрын
Thanks for this, I was trying this on my self worksheet but ending up throwing only single value, and when I tried to put it on a vice versa, it worked. Thanks a lot.
@johnsterling8927
2 жыл бұрын
Simple, elegant and it works. Love it. Thank You.
@muhhammadmonir1790
2 жыл бұрын
Jim you are a gem !
@holtsaburge2005
9 ай бұрын
Thank you. This helps so much.
@shashikalarajapkar8600
Жыл бұрын
Thank you sir for this valid information
@N8riz
4 жыл бұрын
Added 5 if functions within cell, thank you.
@timothythompson7392
4 жыл бұрын
Huge help for nested IF functions! Thank you very much!
@JimFikes
4 жыл бұрын
Happy to help.
@vincevaughan1894
2 жыл бұрын
Keep them coming, awesome tutorial 👍👍👍👍
@cplymale5644
Жыл бұрын
Great explanation!! Thank you so much!! Exactly what I needed.⭐⭐⭐⭐
@PerryCoxPF93
2 жыл бұрын
thanks for this! thankfully Excel has introduced IFS making these long, multiple IF statements much easier to enter.
@CoachJT
7 жыл бұрын
YOU SAVED MY DAY THANK YOU REALLY CLEAR AND PRACTICAL
@grantc8523
8 жыл бұрын
i love you thanks for the video. your the best. been trying to do this homework for an hour
@LilaBdrKarki-kb1mn
7 жыл бұрын
So helpful that i am able to calculate grades students get in different subjects
@venkatesh3543
4 жыл бұрын
Really thank you so much sir.. From India
@jeffboyack5387
2 жыл бұрын
Thank you for making this video!!!
@quameatu
Жыл бұрын
I can't believe is this easy
@Miss.Currently
Жыл бұрын
Thanks for the help, well articulated
@noeldsouza190
4 жыл бұрын
Finally resolved... thank you so much
@ailieschcimmer9633
Жыл бұрын
Thank you so much
@JimFikes
Жыл бұрын
Happy to help.
@TheAbdalla2012
4 жыл бұрын
Thanks a lot. I was struggling with this one.
@MG.50
3 жыл бұрын
Thank you! Minor tweak, and now I see my error.
@cruzmichaelluisq.6701
2 жыл бұрын
This is very helpful sir!
@sw786alvi9
3 жыл бұрын
Thanks for the explanation.
@nitianboypinaki
Жыл бұрын
Thank u sir ❤India
@souadbohsali4997
Жыл бұрын
Thank you 🌼
@sdx1001
7 жыл бұрын
Super helpful! Thank you for your help and videos!
@Jack-eo1nr
2 жыл бұрын
Thank you!
@jimmyabank2220
7 жыл бұрын
These have been very helpful
@quameatu
Жыл бұрын
Thanks a million
@JimFikes
Жыл бұрын
Happy to help.
@8888mzafar
2 жыл бұрын
Life saver
@JBoardOnly
6 жыл бұрын
I tried following for =IF(A1=276,"4")) where I am lookng for values < 55.3 and > 276..... cant see what I'm doing wrong? Can you please assist? The 1 and 4 represents bottom and top quartile values. Thanks,
@missyhel
3 жыл бұрын
Thank you
@adhamsameh1
8 жыл бұрын
saved my life thanks
@ebikombowieamatare120
2 жыл бұрын
Thanks sir
@Rayyantahir879
2 жыл бұрын
Thanks dear! After a long long time i ma able to know how can i fix this issue when i shall maintain my school results. Thank you very very muach
@ukamakaonyekwere7963
2 жыл бұрын
It's not working in my PC it says "YOU'VE ENTERED TOO MANY ARGUMENTS". Does this formula have exceptions, (is there a particular Excel sheet or office it doesn't apply to?) Please reply.
@quameatu
Жыл бұрын
Great lesson .always struggle on the number of brackets Please do more excel videos
@JimFikes
Жыл бұрын
Thanks your feedback. I'll try to do that.
@sarimahjamaludin8185
7 жыл бұрын
very useful..thank to vedio owner
@ruthadere7314
3 жыл бұрын
very important
@dhanujatharuka5178
2 жыл бұрын
🔴 What do we do if we have absent students on the result sheet? 🔴
@production.coppergat
2 жыл бұрын
CAN YOU HELP ME HOW TO SHOW THE FOLLOWING GIVEN BELOW; 8:15AM TO 8:30AM MENTION -1HOUR, 8:31 TO 9:00 MENTION -2HOUR, 9:01 MENTION -4HOURS, 12:00PM MENTION -4HOURS, 3:00PM MENTION -2HOURS, 4:00 PM MENTION -1HOURS ALL THIS IN ONE CELL IS THERE A WAY?
@ajaytomer6504
6 жыл бұрын
Thanks a lot Sir!
@evelynmagiera9636
8 жыл бұрын
Thank you soooo much!!! i go to college in Manhattan . LIM College
@SirLloydClassroom
3 жыл бұрын
Thanks Sir...
@JimFikes
3 жыл бұрын
Very happy to help.
@loyalkishore
2 жыл бұрын
@@JimFikes hi need to assign number to an alphabet for example if I type 183 it's has show AHC in cell so A will be 1 b will be 2 and c will 3 in a cel if I type 123 it has to show ABC can please help me on this
@felixsandoval9239
3 жыл бұрын
THANK YOU!!!
@islamic31399
2 жыл бұрын
Great
@AmirMohammed158
4 жыл бұрын
Thanks a lot
@hafsatbello4814
Жыл бұрын
Please I keep on getting error ⚠️ what should I do
@7AYE22
5 жыл бұрын
I love this
@ashikbhai5232
4 жыл бұрын
Qutta
@oldman4204
6 жыл бұрын
thanks sir
@danielakoyleek3757
2 жыл бұрын
That means 101% will be graded as A as well because it is greater than 90
@sincronex
9 жыл бұрын
hey jim can you correct this for me? Jim Fikes I hope I tag the right jim.. =IF(F47=11=30=40,F47-15))))
@shawol373
8 жыл бұрын
Thanks
@blender3drenders306
7 жыл бұрын
kindly respond to the comments so we know you are still active.
@stevebayt145
Жыл бұрын
what a mess.....the new IFS statement is much easier, just one If and one parentheses at end at begining
@JimFikes
Жыл бұрын
Yep, but my students have to master both the nested if and the ifs functions.
Пікірлер: 86