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