conditional formula: return 1 of 4 values
You're the hero, many thanks......
"Peo Sjoblom" wrote:
Your criteria does not handle if a value is equal to so I had to guess
=LOOKUP(C13,{0;274;329;438},{8;16;24;32})
adapt to fit
--
Regards,
Peo Sjoblom
Portland, Oregon
"Pladdy" wrote in message
...
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
|