If formula

Closed
Mic - Jun 14, 2010 at 03:08 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2010 at 05:38 PM
Hello,

I am trying to do an IF formula in excel 2003. If a certain field is less than 8, than substract that field from 8. I can't seem to get it to work. Please help.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 14, 2010 at 05:38 PM
=if (AND(A1<>"", A1<8), 8 - A1, "Now what")
0