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
|