M Mitch Perala via OfficeKB.com Jan 18, 2005 #1 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.
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.
G Guest Jan 18, 2005 #2 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
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
