conditional formula: return 1 of 4 values
How can i use a conditional formula to return one of 4 values,
if C:13 is less than 274 should be 8,
if C:13 is less than 329 should be 16,
if C:13 is more than 329 should be 24,
if C:13 is more than 438 should be 32.
I know I'm close tough not quite
=(C13<274)*8 + (C13274=16)*(C13<329=24)*24 + (C13438)*32
|