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....................

Reports: ·
Posted 3 years ago