IF function?

[Guest]

I read a post below about using the "if" function for multiple calculations
inside of 1 formula, but I did not quite understand your responses.

My issue is taking 13 values from say cell "L3" and multiplying that value
by a specified formula
=IF(L3=4,D3+50,IF(L3=6,D3*1.5+50,IF(L3=8,D3*2+50,IF(L3=10,D3*2.5+50,IF(L3=12,D3*3+50,IF(L3=14,D3*3.5+50,IF(L3=16,D3*4+50,IF(L3=18,D3*4.5+50,))))))))
Problem being I have 5 more values to add 20,22,24,26,28 how do I do this?
It appeared to me that I needed to incorporate the "or" function but when I
did this it returned an error. Thanks in advance

 

[Vasant Nanavati]

=IF(AND(L3>=4,L3<=28,MOD(L3,2)=0),50+(D3*L3/4),"ERROR")

 

[Guest]

what does the "mod" function do in this formula? the rest I understand.

 

[JE McGimpsey]

Did you look it up in XL Help? It's description is pretty good...

MOD divides the first argument by the second argument and returns the
remainder.

 

[Vasant Nanavati]

In this particular case, it ensures that L3 is an even number.

 

[Guest]

okay with that being said, what exactly is it doing in this formula?

 

[Guest]

it looks like you could use
=50+D3*L3/4 for this calculation

 

[JE McGimpsey]

It returns the remainder of L3 divided by 2.

Going beyond what MOD() is doing, that result is then compared to zero,
returning a TRUE/FALSE result. TRUE would indicate that the value of L3
is both integral and even. FALSE would indicate that it is not integral
and even.

That result is an input to the AND() function. If L3 is not integral and
even, the AND() function will return FALSE, and the result of the False
branch of the IF statement (i.e., "ERROR") will be returned to the cell.