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
Regards,
Prad
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.