IF statement that yields a value based on a formula
IF(B12=0,B12*0.4,IF(B12,0,0))
Click yes if helped
--
Greatly appreciated
Eva
"barbara h" wrote:
Help! If cell B12 = 0, then I need the answer to be calculated based on the
formual "B12 * .40". If cell B12 < 0, then the answer is zero.
How do I do this?
--
barbara h
|