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.
--
David Biddulph

Canon wrote:
Thanks Sheeloo, but what do I replace that with?

"Sheeloo" wrote:

=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...

"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