I need a formula

  • Thread starter Thread starter vdmbqb
  • Start date Start date
V

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.
 
vdmbqb said:
If A2 is greater than zero return 28, if A2=zero return zero.
Click to expand...

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