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
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%?
=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:
- Excel - Display text w/ range of values
- Excel mod apk for pc - Download - Spreadsheets
- Huawei display check code - Guide
- To display a text file in reverse order what command should be used - Guide
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 28, 2010 at 10:28 AM
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
Apr 28, 2010 at 10:58 AM
Apr 28, 2010 at 11:13 AM
=IF(AND(d18>=60, d18<=70), "TEXT", "DIFFERENTTEXT")