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.
--
Message posted via http://www.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.
--
Message posted via http://www.officekb.com
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
"Mitch Perala via OfficeKB.com" wrote:
> 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.
>
> --
> Message posted via http://www.officekb.com
>
Two alternatives for cell A15:
=IF(ISNUMBER(A2),IF(A2-40<0,0,IF(A2-40>40;A2*40,"")),"")
or
=CHOOSE(1+ISNUMBER(A2)+(A2-40>=0)+(A2-40>40),"",0,"",A2*40)
Ola Sandstrom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks