I need a formula

[vdmbqb]

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.

 

[trip_to_tokyo]

=IF(A2=0,0,28)

If my comments have helped please hit Yes.

Thanks.

 

[David Biddulph]

=IF(A2>0,28,IF(A2=0,0,"result undefined"))

 

[Joe User]

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