too many IF's Excel 2003
Try this:
=IF(OR(A1<=0,A117),"",40-A1*2+2)
Biff
"dalmom" wrote in message
...
I need some help... what I need to do is:
IF(a1=1,40,if(a1=2,38))
BUT, I need to make this so that a1 goes all the way to 17 and I need the
value if true to drop by 2 each time.
I tried the trick on pearson site and cant make that work.
I am VBA and macro illerate.
Thank you!!!!
|