SEARCH

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 1 year ago by amrinderminhas
  • Latest reply from Enthusiast
  • Topic Viewed 789 times

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 1 year 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 1 year ago
Top
 
Enthusiast
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 1 year ago
Top
 
amrinderminhas
Posts: 59

thanx

Posted 1 year ago
Top
 
Enthusiast
Enthusiast
Posts: 566

You are welcome.

Posted 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.

Enter Your Email Here to Get Access for Free:

Go check your email!