Prev: Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute
Next: IF statement that yields a value based on a formula
From: barbara h on 11 Feb 2010 11:45
I need to do a calculation based on a cell. If cell B12 >= 0, then I need
to calculate a formula (B13*.40). If cell B12 < 0, then value = 0.

Can anybody help?

--
barbara h
From: Eduardo on 11 Feb 2010 11:48
Hi,

=if(B12>0,(B13*0.40),0)

"barbara h" wrote:

> I need to do a calculation based on a cell. If cell B12 >= 0, then I need
> to calculate a formula (B13*.40). If cell B12 < 0, then value = 0.
>
> Can anybody help?
>
> --
> barbara h
 | 
Pages: 1
Prev: Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute
Next: IF statement that yields a value based on a formula