How to use data validation for multiple condition

February 14, 2017 at 02:49:48
Specs: Windows 7
Dear experts,

I have 1 cell (A2) where data validation exist based on drop down list. I want to use formula based on the drop down value.

e.g. If (A2) = "TIN" then it should allow value range between 3000000000 and 3999999999 and IF (A2) =Blank it should not contain any value and if it (A2) = "FIN" it should allow value starts with 3 but only 15 digit and if (A2) = "CRNo"then it should allow only numeric value


See More: How to use data validation for multiple condition

Report •

February 14, 2017 at 08:01:37
Not sure I understand what it is you want to do.

A cell can contain either a Formula or Data but not both.
So with your Drop Down in cell A2
where is your Data going to be
and what happens if it does not conform to your list?

If you could explain what it is your trying to accomplish it would help.


Report •
Related Solutions

Ask Question