IF questions

A

andiparsons29

Is it possible to setup a question in excel that can have more than two
answers for example:

If over 50 do A
If over 70 do B
If over 90 do C

Thanks
 
M

Mike H

When you say 'Do A' you can't call a macro but you can have an If statement
that checks a value for 3 conditions:-

=IF(A1>90,"Do C",IF(A1>70,"Do B",IF(A1>50,"Do A","Unspecified")))

Because you don't say what you want if the condition is less that 50 the if
statement above will reyrun 'Unspecified'

If you really want to 'Do something' i.e. run a macro then this would
require a different approach.

Mike
 
T

Toppers

=IF(A1>90,actionC,IF(A1>70,ActionB,actionA))

Note order of tests.

There is an Excel limit of 7 IF tests (unless this changed in 2007 whichI
don't have)

HTH
 
Top