Formula with blanks

  • Thread starter Thread starter Canon
  • Start date Start date
C

Canon

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
 
=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...
 
Thanks Sheeloo, but what do I replace that with?

Sheeloo said:
=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...
Click to expand...
 
Thanks David for pointing that out...

David Biddulph said:
You can replace "neither one or zero" with whatever result you want from the
formula when A12 is neither one nor zero.
You will doubtless have realised that the H12 in the formula should have
been H5.
Click to expand...
 
Sorry guys, i'm not picking this up. I need cell C12 to pull the number from
cell H5 when cell A12 is 1, and cell C12 to be blank when cell A12 is 0
 
Canon,

Use this in C12

=IF(A12=1,H5,IF(A12=0,""))

If A12 is 1 it will give you the value in H5, blank if A12 is 0, FALSE if it
is neither 1 or 0
 
Back
Top