If...then "0", if greater than, then enter actual

G

Guest

If value in cell a1 = 1 through 149, display "0" in a2
If vallue in cell a1 = 150 or greater, display actual value of a1, in cell a2
 
B

Bob Phillips

=IF(AND(A1>=1,A1<150),0,IF(A1>=150,A1,""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
G

Guest

Bob,

This is what i'm really trying to get to:
If a1 = 0-149, then a2 = 0
If a1 = 150-200, then a2 = 200
If a1 = 200 or greater, then a2 = a1

Thanks
 
C

CLR

What results would you like if A1 is blank?, or if A1 contains a negative
number?, or if A1 contains any number "between" 149 and 150?, or if A1
cantains TEXT?

If you don't consider those conditions in the formula, Excel will
automatically do it for you and you may not like the results.

Vaya con Dios,
Chuck, CABGx3
 

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

If..display "0", if greater than... display actual 4
Excel Need Countifs Formula Help 0
find the largest value in column, put in a cell 2
Formula help 0
IF THEN 2
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
How to I set a limit on the value returned by a cell 3

Top