Excel Magic Trick 167p2 IF function formula: 12 Examples!

[lera5266]

BBrrilliant!!!



[thisisouraccount]

these r really best videos and u r best man

[ExcelIsFun]

I am glad that the videos help!

[Sailor33195]

Thanks for all you do.

I really appreciate these tutorials.

I enjoy the enthusiasm . . . and speed.

Cheers!

[ExcelIsFun]

You are welcome!

[Sailor33195]

Thanks for all you do.

I really appreciate these tutorials.

I enjoy the enthusiasm . . . and speed.

Cheers!

[ExcelIsFun]

You are welcome!

[vrocavesna]

It's a facbook badge connector. You can create it on your fb page, and the post it in your web page, so if someone is click on it, this badge connect him to FB.

Hope that will post :)

[vrocavesna]

It's a facbook badge connector. You can create it on your fb page, and the post it in your web page, so if someone is click on it, this badge connect him to FB.

[vrocavesna]

Hi, one longer question. If I have to put in one cell formula like that... if WA100 is smaller or equal then 100%, than is 1, if WA100 is bigger then 100% and smaller than or equal 200%, is 2, if WA100 is bigger than or equal 300%, is 3. How should I put this in?

Thank you for the answer.

[ExcelIsFun]

Post question to Mr Excel Message Board:

mrexcel[dot]com/forum

It is too hard to type formulas and what not into the comments

Send me the link after you post it!

[vrocavesna]

@ExcelIsFun

Little tricky question... forum question...

Ok, I did that, I see, that here I wrote it wrong, but I correct it in forum.

And I recommend to do the F badge for fan page in your page. It's easy.

[ExcelIsFun]

I sent reply to Mr Excel Message Board, see if that works.

What is F badge?

[vrocavesna]

@ExcelIsFun

It's a facbook badge connector. You can create it on your fb page, and the post it in your web page, so if someone is click on it, this badge connect him to FB.

[vrocavesna]

@ExcelIsFun

It's a facbook badge connector. You can create it on your fb page, and the post it in your web page, so if someone is click on it, this badge connect him to FB.

[VanLtheMan]

"and" and "or" functions are limited to 30 logical, if you have 41 logical, is there any other options? Is it possible to us table instead? =if(and(a1=code_table,a2=statu­s_table),"High Priority","Normal"). The code_table has 41 options (1a, 1b, 1c…, 2a, 2b, 2c…) and the status_table has 4 options (prospect, initiated, pending, under review). I learned a lot from your vids, thanks for putting them up!!!!

[ExcelIsFun]

One way to get around it is to put some of the logical tests into individual cells. For a simple example with three logical tests: in cell A1 you have formula =B1=12 in cell A2 you have formula =B2>4 in cell A3 you have formula =B3="ABC"

Then in a different cell you have the formula:

=OR(A1:A3)

That is a well know way to avoid the limits for OR, AND, IF and other functions.

[thuynguyenable]

Dear ExcellsFun,

Would you mind explaining the standard Deviation of Population? I understand almost functions in Excel by watching your videos but am not very clear about this standard Deviation of Population. In what situation do we apply this function? Thanks.

[ExcelIsFun]

For a complete explanation see these videos:

Excel & Statistics 39: Variability Chart - Visual Approach (Dispersion or Spread)

Excel & Statistics 41: Sample Standard Deviation (Variability)

STDEVP is for population (all the data points)

STDEV is for sample data (just some of the data)

Standard deviation tells you: 1) spread in data set, 2) whether the mean is reliable or not, 3) it is sort of like an average of all the deviations (deviations are how far each data point is from the mean).

[aman1245singh]

@thuynguyenable standard deviation of a population( as opposed to the sd for a sample) takes into consideration the entire data set or the date in totality. However, sample standart deviation, on the contrary, takes into consideration only a selected part of the data( as a representation of the complete data)

[lovsgms]

Thank you for the time and effort explaining excel to us.

[ExcelIsFun]

You are welcome! Thanks for the 5 star ratings!!

[Ginsagency]

What if you have four out comes? FF, TT, FT, and TF. I'm make a spread sheet that reads. At age 35 start investing some amount (say 400). and At age 38 add a lump some amount of (say 1000). If you have a column of ages from 20 to 60 would I not need three if statement for all out comes? I can get it to work but not for a FF situation. Thanks for all the great videos.

[ExcelIsFun]

Try this video:

Highline Excel Class 35: IF Function Vs. VLOOKUP Function

[Ginsagency]

Thanks.

[asifborouge]

I am looking for a solution to my problem. I am trying to maintain the leave balance record for my shift workers. In excel, each row is dedicated for employee. At the month end, availed/planned vacation "V" is subtracted from the total leave balance. How can I cancel "V" from counting if it is "Public Holiday" druing vacation. As per my formula, two days are deducted or vice versa. My formula is as under:

=32+COUNTIF(C8:AG8,"PH") - COUNTIF(C8:AG8,"V")-COUNTIF(C7­8:AG78,"CDO"). Thanks

Thanks

[ExcelIsFun]

I don't know. You should try the best Excel Message Board around:

mrexcel[dot]com

THE smartest Excelers that I know of hang out at this site.

[asifborouge]

Recently, I came across your videos & really all are helping me. Great videos....

[ExcelIsFun]

I am glad that they help!

[CoachBryantNBHS]

Thanks for the video it was so helpful. I am a teacher and I would like for my students to work along as you demonstrate, do you have this excel file?

[ExcelIsFun]

Sure. Search for this video title and watch this video: excelisfun Search For Excel Videos and Playlists & Download Workbooks

[CoachBryantNBHS]

Thanks for making it simple. Do you have the excel worksheets? I want my students to work along with the video.

[amyfer1091]

This was very Helpful,

Thank You Very Much!

[ExcelIsFun]

You are welcome!

[Mynotoar]

That was really useful :P. I was looking for something which could use nested IFs to return different answers upon evaluating the contents of a drop-down list.

[ExcelIsFun]

Try the video that says "nested IF".

Also, be sure to watch this video title to see when to switch from IF to VLOOKUP:

Highline Excel Class 35: IF Function Vs. VLOOKUP Function

[tienbeo107]

Thank you so muchhhhhhhhhhh! <3

[ExcelIsFun]

Dear tienbeo107,

I am glad that the video helped!!

--excelisfun