If Function test

[dudeski]

Hi Guys,


It's pretty late in the day and my brain is fried so i need your help. I need a basic test to check a few new starters' understanding of the If function. it can be as random as you like. If there is a twist, it would be even better. but bare in mind, these guys are pretty young and their understanding would be intermediate. I assume!


Thanks in advance guys

 

[SirJB7]

Hi, dudeski!

Check this link:

http://chandoo.org/forums/topic/distributing-demand-as-per-selling-price#post-26580

If they could explain both formulas, don't fire them, just test if you too and if don't succeed, well, better get screwed to your seat.

Regards!

 

[jason]

so you just want a couple "Sample IF formulas" to see if these starters understand how they work!? ....talk about an wide open door.


testing on the IF function alone is one thing : IF(Condtion,Value_If_True,Value_If_False)

but nesting other formulas in place of the arguments is 1) taking it WAY beyond one's understandin of this 1 particular funciton and 2) ....well, basicly limitless in possibilities.


Here's a recent one i created:

=IFERROR(IF(VLOOKUP(EOMONTH(B595,0)-DAY(EOMONTH(B595,0)-1),Data,1,FALSE)=(EOMONTH(B595,0)-DAY(EOMONTH(B595,0)-1)),SUM(C595-(VLOOKUP(EOMONTH(B595,0)-DAY(EOMONTH(B595,0)-1),Data,2,FALSE)))),SUM(C595-INDEX(Data,MATCH(EOMONTH(B595,0)-DAY(EOMONTH(B595,0)-1),daterange,1)+2,2)))


completely different and a little more simple:

=IF(WEEKDAY(B37,1)=5,B37,IF(WEEKDAY(B37,1)=1,B37-3,IF(WEEKDAY(B37,1)=2,B37-4,IF(WEEKDAY(B37,1)=3,B37-5,IF(WEEKDAY(B37,1)=4,B37-6,IF(WEEKDAY(B37,1)=6,B37-1,IF(WEEKDAY(B37,1)=7,B37-2)))))))