Thread: IF questions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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