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.
Bookmarks