Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) .... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
007 questions | Charts and Charting in Excel | |||
007 questions | Charts and Charting in Excel | |||
Max / IF questions | Excel Discussion (Misc queries) | |||
Questions??? | Excel Discussion (Misc queries) | |||
I have tow questions: | Excel Discussion (Misc queries) |