Formula with blanks
=IF(A12=0,"",IF(A12=1,H12,"neither one or zero"))
You can replace "neither one or zero" with whatever you want in this
situation...
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...
"Canon" wrote:
Excel 2007
Looking for a formula that will do the follwing;
If cell A12 equals 0 then cell C12 should be blank, if cell A12 equals 1
then cell C12 should equal the sum of cell H5
|