IF questions
 

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

IF questions
 

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(A190,"Do C",IF(A170,"Do B",IF(A150,"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

"andiparsons29" wrote:

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

IF questions
 

=IF(A190,actionC,IF(A170,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

"andiparsons29" wrote:

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

IF questions
 

64 in 2007, I think.

http://office.microsoft.com/en-us/ex...738491033.aspx
--
David Biddulph

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