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
|