Show different result based on value in another cell

[RodneyW]

I'm trying to assign a value in H3, H4, H5, etc. based on data on G3, G4, G5, etc. I currently have this formula in H3:

=IF(G3>30,5) and if the value in G3 is greater than 30, H3 displays 5. If the value is less, it displays FALSE.

What I need is a formula that will look in G3 and if the value is between 0 and 5, H3 will display 1. If the value is between 5 and 15, it will display 2. Between 15 and 30 it will display 3. Between 30 an 50 it will display 4 and greater than 50, display 5. I don't mind changing "5" to "4.999" or "5.001" or similar,

Thanks in advance

 

[luker]

Take a look at the IFS Function. Seems like it will do what you want

 

[RodneyW]

Take a look at the IFS Function. Seems like it will do what you want

I couldn't get that to work, but solved it with a VOOKUP formula