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

(5 posts)
• Started 4 years ago by amrinderminhas
• 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 4 years ago

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 4 years ago

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 4 years ago

amrinderminhas
Posts: 59

thanx

Posted 4 years ago

Enthusiast
Posts: 566

You are welcome.

Posted 4 years ago

## Topic Closed

This topic has been closed to new replies.