How can I set up a formula in Excel to perform only if the value in a cell is greater than zero?
B barbaraatm May 26, 2006 #1 How can I set up a formula in Excel to perform only if the value in a cell is greater than zero?
E Elkar May 26, 2006 #2 Something like this: =IF(A1>0,yourformula,"") Replace yourformula with whatever calculation you need. HTH, Elkar
Something like this: =IF(A1>0,yourformula,"") Replace yourformula with whatever calculation you need. HTH, Elkar