View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default 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