Message to user of which to select in 3 different drop downs.

[Skiroy]

Hello,

I'm currently working on trying to have a warning box that indicated when the drop downs have not been selected, but I'm coming back with too many formulas for this one box.

Currently I have:

=IF(AND(B4="Choose Current Grade", B6="Choose Proposed Grade", B8="Select Geographic Range"), "Error! Select Current Grade, Proposed Grade, and Geographic Range", IF(AND(B4<>"Choose Current Grade", B6="Choose Proposed Grade",B8="Select Geographic Range"), "Error! Select Proposed Grade and Geographic Range", IF(AND(B4<>"Choose Current Grade", B6<>"Choose Proposed Grade", B8="Select Geographic Range"),"Error! Select Geographic Range",IF(AND(B4<>"Choose Current Grade",B6<>"Choose Proposed Grade",B8<>"Select Geographic Range"),""))))

It works fine if you go in order B4 to B6 to B8, but if the drop downs are picked in a different order B8,B6 then B4 I'm getting false back. I want to cover all eventualities of this formula to indicate to the user which one needs to be completed.



Any help is always appreciated

 

[Chrisdontm]

See if this is what you want;

=IFERROR(CHOOSE(SUM(IF(B4="Choose Current Grade",1,0),IF(B6="Choose Proposed Grade",2,0),IF(B8="Select Geographic Range",4,0)),"Error! Please Select Current Grade, Proposed Grade, and Geographic Range","Error! Please Select, Proposed Grade","Error! Please Select Current Grade, Proposed Grade","Error! Please Select Geographic Range","Error! Please Select Current Grade, and Geographic Range","Error! Please Select Proposed Grade, and Geographic Range","Error! Please Select Current Grade, Proposed Grade, and Geographic Range"),"")