> Thank

[limo2088]

How can create a formula which based on looking at a number will give me the following results, i can get it to work for the first ones but cannot seem to do it multiple times


37 This one is >30

93 This one is >90

124 This one is >120

Book1
	D	E
3
4	<30	33
5
Sheet1

Cell Formulas
Range	Formula
D4	D4	=IF(AND(E4>30,E4<60),"<30")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D4	Cell Value	="Over"	text	YES

 

[Joe4]

Is this what you are looking for?

=IF(E4>120,">120",IF(E4>90,">90",IF(E4>30,">30","<=30")))

 

[limo2088]

Is this what you are looking for?

=IF(E4>120,">120",IF(E4>90,">90",IF(E4>30,">30","<=30")))

Thank you very much, I should have explained it better, so if the number is
>30 and <60 I need it to say >30,
if a number is >60 and <90 needs to say >60
If a number is >90 and <120 needs to say >90
and anything over 120 would just say >120
Thank you again

 

[Joe4]

Thank you very much, I should have explained it better, so if the number is
>30 and <60 I need it to say >30,
if a number is >60 and <90 needs to say >60
If a number is >90 and <120 needs to say >90
and anything over 120 would just say >120
Thank you again

Then you only need to insert/nest one more IF in my formula (hopefully, you are starting to see the pattern!)

=IF(E4>120,">120",IF(E4>90,">90",IF(E4>60,">60",IF(E4>30,">30","<=30"))))

Also, you want want to revisit your logic to determine what you want return if it equals EXACTLY 30, 60, 90, or 120.
You might want to change some of those ">" to ">=".

 

[limo2088]

Then you only need to insert/nest one more IF in my formula (hopefully, you are starting to see the pattern!)

=IF(E4>120,">120",IF(E4>90,">90",IF(E4>60,">60",IF(E4>30,">30","<=30"))))

Also, you want want to revisit your logic to determine what you want return if it equals EXACTLY 30, 60, 90, or 120.
You might want to change some of those ">" to ">=".

Perfect, again thank you!

 

[Joe4]

You are welcome.
Glad I was able to help!