Excel Formula
Solved/Closed
meesh97
Posts
3
Registration date
Monday February 10, 2014
Status
Member
Last seen
April 25, 2014
-
Feb 10, 2014 at 03:07 PM
meesh97 Posts 3 Registration date Monday February 10, 2014 Status Member Last seen April 25, 2014 - Feb 10, 2014 at 08:50 PM
meesh97 Posts 3 Registration date Monday February 10, 2014 Status Member Last seen April 25, 2014 - Feb 10, 2014 at 08:50 PM
Related:
- Excel Formula
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel apk for pc - Download - Spreadsheets
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 10, 2014 at 07:53 PM
Feb 10, 2014 at 07:53 PM
meesh97, Good evening.
Suppose your data is at D4.
To do exactly what you want, try to use this:
=IF(D4>50,"High",IF(D4>10,"Mid",IF(D4>1,"Low","")))
You need to determine what to do IF your data is EQUAL or MINOR than 1 ( <=1 )
If this won't happen, you don't need to modify nothing on the formula.
Please, tell us if it worked for you.
Have a nice day.
Suppose your data is at D4.
To do exactly what you want, try to use this:
=IF(D4>50,"High",IF(D4>10,"Mid",IF(D4>1,"Low","")))
You need to determine what to do IF your data is EQUAL or MINOR than 1 ( <=1 )
If this won't happen, you don't need to modify nothing on the formula.
Please, tell us if it worked for you.
Have a nice day.
Feb 10, 2014 at 08:50 PM
Thank you!