Multiple "IF" function

[john_Atkinson]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do I create a function for multiple conditions? For example, if a>1, then b, if a>2, then c, if a>3, then d

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do I create a function for multiple conditions? For example, if a>1, then
b, if a>2, then c, if a>3, then d

If it's really that simple a set of "a", you can use CHOOSE()

For more complicated values of "a" personally I'd recommend using MatLab
or R , but you could look into either creating an array and using
VLOOKUP(), or some ugly thing like

IF(a>6.4,{do
something},IF(a>6.3,{dosomethingelse},IF(a>6.2,{anotherthing},....)))))))