Since your data follows a consistent pattern, do you really need IF statements?

=40-(A1-1)*2

HTH,
Elkar


"dalmom" wrote:

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!!!!