Excel Magic Trick 452: IF Function Formula 16 Examples

1-4) IF function To Put Label on Income Statement. See four different Logical Tests for the same result.
5) IF function using comparative Operator to put one of two formulas in a cell
6) 2 IF functions in one formula (Multiple IF functions)
7) IF function to see if two columns are in Balance
8) IF function to see if accounts are in Balance from different Sheets
9) IF function formula to show or hide a formula
10-11) IF function formulas to see if Invoice or Loan in Past Due
12) IF function for column in data set to determine which products are stored IN house and which ones are OUT oh House. See the NOT operator in a formula.
13) IF function to calculate Commission Bonus
14-15) Multiple IF functions in one formula, then switch to VLOOKUP or LOOKUP
16) IF array formula for MEDIAN calculation

Category:

Science & Technology

Tags:

• Excel
• IF
• Function
• Formula
• Statement
• Nesting
• Array
• Logical
• Test
• for
• Median
• Commission
• Calculation
• column
• or
• field
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[DJYellowbone]

this is more finance if functions, any where i can find if functions dealing with text and numbers? Example if a2 has a 6, then b2 should say dog. I have over 6 numbers and 60 words/statements.

[ExcelIsFun]

Try this video title:

Highline Excel Class 35: IF Function Vs. VLOOKUP Function

[brussli]

VERY Helpful!

Thanks

[ExcelIsFun]

You are welcome!

[master1820461]

Dude you were very helpful with these tips and tricks, without the knowledge I took from this video i wouldn't have got my excel college homework done. Thank's Man

[MichaelMudde]

@ExcelIsFun

Me too, now, this will save me a lot of time in the future

[ExcelIsFun]

I am glad that the video helps!

[ExcelIsFun]

I am not good with VBA. You should try the Mr Excel Message Board:

mrexcel[dot]com/forum

[288279]

i am trying to create a button to calculate for example FV run by macro button can you help with this matter. and thank you very much for these videos i learned a lot from you and god bless you.

[ExcelIsFun]

You are welcome!!