Excel Formula
Solved/Closed
meesh97
Posts
3
Registration date
Monday 10 February 2014
Status
Member
Last seen
25 April 2014
-
10 Feb 2014 à 15:07
meesh97 Posts 3 Registration date Monday 10 February 2014 Status Member Last seen 25 April 2014 - 10 Feb 2014 à 20:50
meesh97 Posts 3 Registration date Monday 10 February 2014 Status Member Last seen 25 April 2014 - 10 Feb 2014 à 20:50
Related:
- Excel Formula
- Formula to calculate vat in excel - Guide
- Grade formula in excel marksheet - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
10 Feb 2014 à 19:53
10 Feb 2014 à 19:53
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.
10 Feb 2014 à 20:50
Thank you!