If..display "0", if greater than... display actual

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
see response in public.excel

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
=IF(ISTEXT(A1),"",IF(AND(A1>=1,A1<=149),0,IF(A1>=150,A1,"")))

This will return a blank cell for a value in A1 that is "less than 1", "any
number that is greater than 140 and less than 150", "and any
text"...........otherwise, it will do as you ask.....

Vaya con Dios,
Chuck, CABGx3
 
Dave,

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
 

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

find the largest value in column, put in a cell 2
If...then "0", if greater than, then enter actual 5
Excel Need Countifs Formula Help 0
greater than.. 5
Cell blank 4
Excel formula, sum the value cell and if empty cell left blank 0
If statement for a range of cells 3
if, then display next cell 4

Back
Top