• ARTICLES
• SUBSCRIBE
SEARCH

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

(5 posts)
• Started 1 year ago by amrinderminhas
• Topic Viewed 705 times

• 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 1 year 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 1 year 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 1 year ago #

amrinderminhas
Posts: 59

thanx

Posted 1 year ago #

Enthusiast
Posts: 566

You are welcome.

Posted 1 year ago #

## Topic Closed

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