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 |