The How-To Geek Forums Have Migrated to Discourse


How-To Geek Forums / Microsoft Office

(Solved) - How to apply "IF FORMULA"to the following simple problem.....????

(5 posts)
  • Started 3 years ago by amrinderminhas
  • Latest reply from Enthusiast
  • Topic Viewed 789 times

PARTNER SPOTLIGHT

Recommended: Clean Your PC the Easy Way with CleanMyPC

If you want to clean up your PC the easy way, CleanMyPC is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyPC for Free Today

Posted yesterday 
Top
amrinderminhas
Posts: 59

Hello to all,
I have this simple problem in which there are number values from 30 to 100 (Ex: 34, 37, 78,47,98,81,56,65 etc..) towards down the cell i.e.. in A1, A2, A3.. cells.
I just want to apply the formula such that in next cells corressponding to these nos. this formula becomes applicable...

If no. is below 65 then the value should be 0,
If no. is between 65 to 75 then value in next cell be displayed as 2
If no. is between 76 to 80 then value in next cell be displayed as 3
If no. is between 81 to 85 then value in next cell be displayed as 4
If no. is between 86to 90 then value in next cell be displayed as 5
If no. is between 91 to 100 then value in next cell be displayed as 6.

KIndly provide me the IF COMMAND Formula to solve this....

THANX....................

Posted 3 years ago
Top
 
amrinderminhas
Posts: 59

kindly provide me with some answer. I know its nothing tough fpr u guys as u hv solved most tedious problems of mine before...

Posted 3 years ago
Top
 
Enthusiast
Posts: 566

The formula you are looking for is:

=IF(A2>90,6,IF(A2>85,5,IF(A2>80,4,IF(A2>75,3,IF(A2>64,2,0)))))

This assumes your data starts in A2. If it does not, make sure to change the "A2" to whatever cell holds your number.

Accepted Answer · Posted 3 years ago
Top
 
amrinderminhas
Posts: 59

thanx

Posted 3 years ago
Top
 
Enthusiast
Posts: 566

You are welcome.

Posted 3 years ago
Top
 



Topic Closed

This topic has been closed to new replies.