If Functions

[watson86]

I am trying to create a series of IF functions so that the cell will register a number based on the value of the previous cell. Basically something like this:
If S6>=30, then S7 should read 25
If S6 is between 31-59, then S7 should read 20
If S6 is between 60-75, then S7 should read 15
If S6 is between 76-89, then S7 should read 10
If S6 is between 90-100, then S7 should read 3

I have tried nesting the cells and using a variety of symbols, but still nothing is working it will give me the "25" value but nothing else.

I would greatly appreciate some help!

 

[Marcílio_Lobão]

watson86, Good morning.

All the above suggestions work PERFECTLY!

See this template where all the hints are working.

https://www.sendspace.com/file/p45q1z

I hope it helps.

 

[FDibbins]

I-don't-know-how-to-do-that-(thepostwontletmespace

Create a small table, just like I did, then put my formula where you want the answer to be - and adjust my ranges to suite your data