cell value between numbers

[mimuska27]

Hi, can someone help me with a simple formula? Basically if value in a cell is
between 91-100 the return value is 60, if
between 90-81 the return values is 30, if
between 80-71 the return values is 15, if
between 70-0 the return value is 0.

Thank you very much.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(A2<=70,0,IF(A2<=80,15,IF(A2<=90,30,60)))

 

[Alex Blakenburg]

Based on your question I think Fluff's response will be easier for you.
What you are doing screams out for using Vlookup though, which would be easier to maintain in the future, especially if you set up the lookup table as an Excel Table.

20210623 If or Vlookup.xlsx
	A	B	C	D	E	F	G
1
2	Lookup Range
3					Without Table
4	From	To	ReturnValue		Test Value	Return
5	0	70	0		95	60
6	71	80	15
7	81	90	30		With Table
8	91	100	60		Test Value	Return
9	101		Out of Range		95	60
10
Test Data

Cell Formulas
Range	Formula
F5	F5	=VLOOKUP(E5,$A$5:$C$9,3,TRUE)
F9	F9	=VLOOKUP(E9,tbl_LookupAmt,3,TRUE)