If statement...

**Snowmonster** · 02-09-2011, 10:13 AM

Hi...

I am trying to find a way foe my 'IF statement to recognize a dropdown box input so I can run it like a normal IF statement, si there a way?

Thanks for your time...

Ade...

**NBVC** · 02-09-2011, 10:23 AM

What kind of dropdown?

Is it data validation, Combo Box from Forms menu, Combo box from Controls Toolbox?

**Snowmonster** · 02-09-2011, 11:37 AM

It's a 'Data Validation', thanks

**NBVC** · 02-09-2011, 11:54 AM

If it is data validation, you should be able to simply point to that cell.

e.g. if the data validation is in A1, then formula like: =IF(A1="Yes","Ok","Not Ok") should work which, in this case, just checks that you have select "Yes" in A1 data validation.