Previous Topic Next Topic

Excel - Display text w/ range of values

Closed
ja6924 - Apr 28, 2010 at 09:46 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 28, 2010 at 11:13 AM
I'm trying to get text displayed in a cell when the value is between a range of numbers. Example when the value of cell d18 is between 60% & 70% I want the cell to display the text "Warning". I can easily do this for a single value in this example formula

=if(d18=60%,"Warning","Good")

But how do I get that same text displayed if the cell's value equals any number between 60% and 70%?

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 28, 2010 at 10:28 AM
60-70 of what. 10 is 10% of 100 but 100% of 10. So you need to add that information
0
ja6924
Apr 28, 2010 at 10:58 AM
Another formula creates the value of D18. In cell E18 I want to write a formula. In that formula, if the value of cell D18 is between a set of numbers, like between 60 & 70 then display "TEXT" in E18. if the value of cell D18 is not between 60 & 70, then display "DIFFERENTTEXT" in E18. Forget about the %. Say cell D18 = any # between 60 & 70, then I want "TEXT" to be displayed in E18. Say cell D18 = any # between 0 & 59 or between 71 & infinty, then I want "DIFFERENTTEXT" displayed in E18.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 28, 2010 at 11:13 AM
In that case

=IF(AND(d18>=60, d18<=70), "TEXT", "DIFFERENTTEXT")
0

Similar discussions

Computer turns on but no display
Lancenz -
Lancenz -

2 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
No display on monitor, light blinks
Harsh20_4 -
Anonymous -

9 responses
My PC beeps 5 times and it wont display
noorytaha -
noorytaha -

4 responses