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.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help for a formula 5
Average problem 1
excel formula 1
Merged cells and formula data sources 10
#N/A problem 6
How do I make this work? 15
conditional formula using sumproduct 9
Excel multiple conditional formulas 3

Back
Top