Show text for these following parameters?

[Mr.Castle]

I need a formula to show text in cell I6, for these following parameters?

If I6= Between 0-10 than text 'F'
If = Between 11-19 than text 'D'
IF = Between 20-29 than text 'C'
If = Between 30-39 than text 'B'
If = Between 40-50 than text 'A'

[¯\_(ツ)_/¯]

You can't have a formula in cell I6 that checks the value of cell I6 and changes itself to a text value. You could do this in another cell, or use a macro that checks whenever a change occurs in cell I6 (does not include changes due to formulas).

So if I6 had 23 in it, then J6 (for example) could use the formula:

Please Login or Register  to view this content.

[CK76]

Try...
=LOOKUP(I6,{0,11,20,30,40},{"F","D","C","B","A"})

Note: Anything over 40 will return A.

Edit: Din't see that you wanted in same cell as data entry. Do above in another cell, as noted by previous poster.

[Mr.Castle]

No the formula will be put in another cell, I6 is the number that the formula would identify, to show the result in another cell.

[Fluff13]

You can do that with Cf
Select I6 > CF > New rule > Use a formula > enter =OR(I6>=0,I6<=10) >format > Number > Custom > "F" > OK
The do the same for the other values

[Mr.Castle]

Its possible to make the formula ignore blank cells?

[¯\_(ツ)_/¯]

Please Login or Register  to view this content.

[Mr.Castle]

The formula worked ,
Thank you ¯\_(ツ)_/¯ and everyone for the help.