SEARCH

The How-To Geek Forums Have Migrated to Discourse



Join the Discussion at discuss.howtogeek.com

How-To Geek Forums / Microsoft Office

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

(5 posts)
  • Started 9 months ago by amrinderminhas
  • Latest reply from Enthusiast
  • Topic Viewed 560 times

  • View Accepted Answer
  • Remove Solved Status
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 9 months 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 9 months 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 9 months ago #
Top
 
amrinderminhas
Posts: 59

thanx

Posted 9 months ago #
Top
 
Enthusiast
Enthusiast
Posts: 566

You are welcome.

Posted 9 months ago #
Top
 



Topic Closed

This topic has been closed to new replies. Please create a new topic instead.


Create New Topic Return to Forum