If function

  • Thread starter Mitch Perala via OfficeKB.com
  • Start date
M

Mitch Perala via OfficeKB.com

If A2 minus 40 is less than zero then display zero in A15, or if A2 minus 40 is greater than 40 then run multiply A2 by 40 and display that in A15.
 
T

tjtjjtjt

Put one of these in A15.

If you don't need to account for exactly zero:
=IF(A2-40<0,0,A2*40)

If you do need to account for exactly zero and want to just return zero in
the cell, you might try something like:
=IF(A2-40<=0,0,A2*40)

tj
 
Top