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.