I have a formula in A2 that generates a number from other cells. I need a
formula in B2 that answers this requirement;

If A2 is greater than zero return 28, if A2=zero return zero.

Thank you in advance for this help.
--
bob

=IF(A2=0,0,28)

If my comments have helped please hit Yes.

Thanks.

"vdmbqb" wrote:

I have a formula in A2 that generates a number from other cells. I need a
formula in B2 that answers this requirement;

If A2 is greater than zero return 28, if A2=zero return zero.

Thank you in advance for this help.
--
bob

=IF(A20,28,IF(A2=0,0,"result undefined"))
--
David Biddulph

"vdmbqb" wrote in message
...
I have a formula in A2 that generates a number from other cells. I need a
formula in B2 that answers this requirement;

If A2 is greater than zero return 28, if A2=zero return zero.

Thank you in advance for this help.
--
bob

"vdmbqb" wrote:
If A2 is greater than zero return 28, if A2=zero return zero.

If you also want 28 if A2 is less than zero or if that situation cannot
arise:

=28 * (A2<0)

If A2 can appear to be blank, but it really contains the null string (""),
then:

=28 * (N(A2)<0)


----- original message -----

"vdmbqb" wrote in message
...
I have a formula in A2 that generates a number from other cells. I need a
formula in B2 that answers this requirement;

If A2 is greater than zero return 28, if A2=zero return zero.

Thank you in advance for this help.
--
bob