Previous Topic Next Topic

If formula

Closed
Mic - 14 Jun 2010 à 15:08
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 14 Jun 2010 à 17:38
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
14 Jun 2010 à 17:38
=if (AND(A1<>"", A1<8), 8 - A1, "Now what")

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses