Thread: IF questions
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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