View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pladdy
 
Posts: n/a
Default 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