Excel IF function

[@SG-fb8dk]

Really great!!! There a lot of videos on Excel formulas, but yours is truly exceptional. You are a great teacher because you are clear, thorough and mainly not rushed. Thank you!!!!

[@maureenlymer9797]

I have watched numerous excel videos on utube and I find Jalayer Academy the most helpful. He sounds relaxed, speaks plain English and is very articulate. I will definitely look up more of his videos.

[@alexandryamosel3476]

i just wanted to thank you for being the only person who did a tutorial on this for actually helping my understand it. i was gonna cry doing my homework for my excel course before watching this

[@jeanmarieleone6741]

Thank you. Excellent , clear step by step in clear language. Well done you. Very appreciated.

[@buraktezcan2307]

you explained very clear rather than other instructors thanx for everything

[@nerdatheart94]

I recently had an exam on IF statements. I couldn't do any of the problems. But after watching this video, I now know what I did wrong, and I am ready for this week's final exam! Thank you!

[@Ivan-ud1gr]

Thank you man, the details you included solved literally an hour of headache.

[@1RaShel1]

Short, simple, and to the point. I learned what I needed to know just watching the first 3-4 mintues of the video.

[@ClementOng123]

you have really saved many students' lives :) thanks man!

[@anthonyyung4554]

Million thanks for your teaching. It is very useful to my daily jobs.

[@rdjalayer]

I learned under pressure situations at work, I never took a course on Excel. Practice with real-life problems and you will learn by solving these problems.

[@fells238]

I am really in need of help with a Nested IF function to calculate how many of the 45 pieces were picked between two time periods. I need to know how many were done within 8am - 9am and 9am -10am and so on during the 8 hour day. If I have 45 pieces picked from 8:30 am to 9:15 how do I write this function?

[@rdjalayer]

thanks for the comment, unfortunately I have not made this file available, you can perhaps create a similar example to practice using this one as a guide

[@tinapenagonzalez3924]

Great explanations!! Can you please provide a copy of the worksheet to download and practice?

[@rdjalayer]

glad I could help, thanks for your thoughtful comment

[@ChimeratAlpha]

For the last one, would it have been possible to use another IF to see if both the D and E column have "yes"?

[@FergieSaenzCR]

Love the way you explain these things! I really appreciate it!

[@nathandavis5730]

Thanks for sharing mate. Find your videos very useful and easy to understand, nice work!

[@purbaghosh5540]

very useful Excel video.It has saved my time.Thank you.

[@boyzndahood781]

Which recorder did you used , great video btw

[@one4rmedgamingone4rmedgami83]

Thanks man. I have a test tomorrow on this and ur video really helped me

[@herns18]

Great video....you're a great teacher. Please post more!

[@roberson2603]

I am learning a lot from your videos. Do you offer a course in excel formulas?

[@Frenchandloveit]

You sir are my Excel HERO!!!! Thanks for teaching me :)

[@unchainedwarriortv]

Brillaint!! Thanks a million for these straight forward videos.

[@gentkvm]

Thanks a lot for the tutorial. I have a huge list of arrival and departure flights to and from AMS (Amsterdam). I want all the values of the flights departing from AMS to be maintained and all the flights arriving AMS to be deleted. How do I do so? Thanks a lot

[@wesleyreiber5643]

thank you man. you saved my ass on a huge exam

[@MickyAvStickyHands]

Is there a function to hide cells that don't fit the desired criteria?

[@allanwaters9782]

Cannot you just use a nested IF statement to calculate the last column?

[@rdjalayer]

yes, and I have a tutorial on nested IF functions with examples, this video was to start with the basics of IF function

[@roelmorales6288]

Hi there, how can I use the if function if I need more then 2 results, in my case there are 3 answers.

[@rdjalayer]

to have more than 2 outputs you can do a nested if function, I have a couple videos for those as well on my channel, Jalayer Academy, just search my channel for nested if function

[@Justyou639]

thanks for your video, great explanation! does it matter with MS on Mac?, I did the same thing you did on my Mac, the formula looks correct, but the result is notcorrcet I dont know why!,

[@dreamaway321]

thanks again Jalayer academy saves to day!

[@marlonnartea7825]

how do you measure a temperature using the "if" function? i have a data, and in data there is a parameter, how do you use parameter?

[@rdjalayer]

thanks for the comment brother

[@rdjalayer]

you must nest an AND inside the IF to do this, watch my nested if function videos

[@jennifercecena6509]

I have been looking for hours on Excel videos and still can't find the formula I need. I have a list of names and on 2nd column I have "here, "out", Resigned", No Show No Call." I need the formua to tell me how many "outs" I have in total. Or how many "here's"...can you please help me?

[@arulmurugan5363]

sir how to creat the nane is used?

[@taylorunderwood-theoriginal]

Say I have a couple of rows and columns with different numbers in each space can I use this to find a specific number if the sum adds up to that number I'm looking for. I would think it'd be this. disclaimer I'm new to excel =if(sum a1,a6 =21,"yes","no")

[@taylorunderwood-theoriginal]

like I said I'm new to this stuff just giving it a swing at it

[@OUTPOST209]

Thank you, really well explained and appreciate your time to put this together

[@ashrafosman7845]

Great content man!

[@kevkevkrunch]

Thank you loadssss! Cant express my gratitude towards you & this video :)

[@rdjalayer]

Your welcome, thanks for watching

[@seansearle9340]

Can I have if I payed money out it takes it away from the total but if I payed money in it adds to the total If so how do I do it

[@britishmiller3665]

Thank you. This was well explained.

[@mariefurcy9270]

Thanks a lot.This was very helpful

[@AK-jy6fw]

Easy to understand, thank you.

[@RameshSharma-hi9ti]

Dear Sir, i m trying the above formula in excel sheet it found some problem with this formula. Try clicking insert function on the formula tab to fix it. its comes when i tried the formula.

[@aamirairborne]

I am trying to give the same formula on my spreadsheet, but it aint working. Could you please help? =IF(G2="Male","Mr.","Ms.")

[@orioljulia8497]

Thats really well explained. Thank you

[@thedaimh9316]

how if i want the result is both of "text" and function? for example the result is (yes "this is RED") . "this is RED" is text and Yes from fuction. thanks

[@marccont01]

Thanks! That was very helpful and well explained.

[@brendaavila4128]

What if the "Attribute A" had multiple words and you were only looking for the word "red" how would I do that? So it can figure out it has the word Red in the sentence.

[@christimccully7687]

Thanks for the clear explanation!

[@bluesbender69]

Awesome teaching!

[@patchichester5296]

Like your video's very much, I'm learning lots. I love excel and like learning more.

[@imitation_life]

=IF(AND($B4=K$3, $D4=$I$5),"Yes","No") Can you tell me why this formula would generate a "No" when both B4 and D4 are equal to K3 and I5 in my worksheet?

[@viralsv3767]

Thanks a lot....Using IF Function in Excel seems much easier now

[@victoriamwaba]

Thank you J this is easy.

[@Mriftach]

great video , very useful!

[@user-ym7hd6vr3h]

Dude, you're the man! Thanks you. This was really helpful!

[@tomking3684]

Great Vid, Keep up the good work

[@simon11889]

can someone explain the part with the End

[@KK-dd1qe]

It's very well easy understanding the function of excel.

[@debbiehodge9978]

Thank you so much very well explained.

[@hamza_2049_]

i have a computer exam & i can not studdy. thanks man for solving my problem

[@deviage]

Thanks for solving my headache!!

[@prezz3]

thanks for your work!

[@maksudurmasud7835]

sir i want to know use if,and or in one result sheet

[@rdjalayer]

go to my channel by clicking the logo and search "advanced if functions"

[@psybera1987]

A B 1 Fruits Others 2 apple Cup 3 orange Glass 4 Watermelon Mirror 5 Grape Bottle 6 mango Desk how'd i let c1 decide if A2=A2:A6 then let C1=fruits if not then let c1=others?

[@MirageP911]

Well explained

[@rdjalayer]

put double qoutes, like this "", so =if(a>b,"Yes","") hope this helps

[@johnbroadbelt]

awesome bro !! thankyou very much !!

[@sabinalohorung5781]

its very easy to understand. Thankyou so much>

[@r2d239]

THANK YOU..this was very helpful

[@alisond7395]

This is a really helpful tutorial - thanks :-)

[@ronanrb85]

thank you so much this really helped me.

[@soniaassou9639]

please help me put this into function. If individual Hybrid is 10 then SME Hybrid is 9.

[@ahmad.s4723]

Great help, much appreciated :)

[@yiuyiubbloveme]

thank you sir！I watched your video TO DO MY business statistics assignment~

[@MyFirstReurveBow]

thanks for a clear explanation/tutorial :-)

[@paulonubah3223]

Please help me resolve this: IF(A5=>0,*0.2/465,0) If A5 is greater than 0 then multiply by 0.2 and divide by 465 if not return 0

[@rdjalayer]

+Paul Onubah I think this is what you are trying to do: if(A5=>0, A5*(0.2/465), 0)

[@patchichester5296]

Question can't find answer: Copy words from above. If I type D it completes with David. If I type K it completes it with Kathy. Sometimes It doesn't do it. If I type R It's not filling in Ralph. There are NO spaces above it's just another name in the list, and there are no other R's in the list? I hope you can help me. I tried to do an IF but don't know how, so I thought having the names above would be better. Thanks, Pat

[@romualdkinimo1004]

extremely helpful...Thank you

[@ruwanthusitha7184]

well done, highly appreciated,,,

[@krmotionexcel]

Please make different different logical example s If -And-OR........... Do it..........please

[@arunrharisree]

very helpful.. Thank you

[@maxrobinzak]

Very, very helpful.

[@fhmnoor]

thank you for the tutorial

[@rubanv8439]

This is really nice class

[@rdjalayer]

glad you enjoyed it

[@albertobenitez695]

thanks nicely explained

[@sindhu825machado]

Sir how to count the number of yes and no

[@rdjalayer]

see my countif tutorial this will count whatever you want based on the condition you specify

[@rdjalayer]

+Sindhu Machado countif

[@malekawright4233]

thank you it help me lots

[@chandrakantpatel8756]

how to use, if and function in excel templates in taxable social security benefits in publication p 915 of irs. help thank u

[@yahya89able]

greaaaaaaaaaaaaaaaaat u saved me hours man thanks

[@sachinb003]

Very, very, very useful

[@Vjoy12]

I LOVE YOU sir... FOR this video

[@tetsurin5154]

Voice over's too long, but it's very helpful all the way. Thanks

[@pepeijngiezen4105]

Very helpfull!