How to Return a Value If In a Specified Set of Numbers

[MechEst]

Hello Gurus,

I'm stuck trying to figure out the proper syntax for returning a value for a set of numbers.

e.g. - If cell C7 = 8" - 24", then .5, if not, 0; If C7 = 25" - 40", then .75; if not, 0; If C7 = 41" - 60", then 1, if not, 0

The inches are ranges the cell value must fall in to return the specified value.

Any help would be greatly appreciated.

Thank you in advance.

[oeldere]

use VLookup for that kind of work.

edit.

8" - 24" 0,5 0 0,00
8" - 24" 0,50
25" - 40" 0,75
41" - 60" 1,00

=Vlookup(A9,$C$9:$D$12,2,0)

[JohnTopley]

Assuming whole inches ..

=IF(C7>60,0,IF(C7>40,1,IF(C7>24,0.75,IF(C7>=7,0.5,0))))

Not sure if test > 60 is required: it is redundant if 60 is never exceeded.

[Tony Valko]

How will you be entering the value in C7?

Will it be just a number like 10? Will it only be whole numbers or can it be a decimal like 10.5?

Or, will it be the number and the quotes like this 10"? Or, will it be the whole string like this 8" - 24" ?