Trying to do IF THEN Formula with >=/<= with multiple ranges

[SamMold]

Please help!

I am trying to create an IF formula using multiple ranges ranging from 0-8=.5, 9-16=1, 17-24=1.5, etc. and I am having a terribly hard time figuring out how to write it. I use google sheets for excel and would greatly appreciate some insight as to how I can create a formula that actually works. Currently, the formula I tried is "=IFS((C3>=0,C3<=8),0.05,IF(C3>=9,C3<=16),1,IF(C3>=17,C3<=24),1.5,IF(C3>=25,C3<=32),2,IF(C3>=33,C3<=40),2.5,IF(C3>=41,C3<=45),2.75,IF(C3>=46,C3<=49),3)". I've tried multiple tweaks to it but haven't had any success. If you have any insight, please help!

Thank you

 

[Fluff]

How about

=IF(C3<=8,0.05,IF(C3<=16,1,IF(C3<=24,1.5,IF(C3<=32,2,IF(C3<=40,2.5,IF(C3<=45,2.75,IF(C3<=49,3,"")))))))

In future when asking for a Google Sheets formula please post in the General Discussion & Other Applications section of the board & make it clear that it's for sheets.
Thanks

 

[SamMold]

How about

=IF(C3<=8,0.05,IF(C3<=16,1,IF(C3<=24,1.5,IF(C3<=32,2,IF(C3<=40,2.5,IF(C3<=45,2.75,IF(C3<=49,3,"")))))))

In future when asking for a Google Sheets formula please post in the General Discussion & Other Applications section of the board & make it clear that it's for sheets.
Thanks

Thank you, sorry I didn't know I had to post it to a certain area. The formula did work. Thank you so much for your help!

 

[jtakw]

Hi,

Also try this, not sure if it works in Google sheets:

Book3.xlsx
	C	D
3	0	0.05
4	8	0.05
5	9	1
6	18	1.5
7	32	2
8	33	2.5
9	44	2.75
10	48	3
11	49	3
12	51	Out of range
Sheet942

Cell Formulas
Range	Formula
D3:D12	D3	=IF(C3="","",LOOKUP(C3,{0,9,17,25,33,41,46,50},{0.05,1,1.5,2,2.5,2.75,3,"Out of range"}))

 

[Fluff]

The formula did work. Thank you so much for your help!

You're welcome & thanks for the feedback.