Limit in data validation list

[jaryszek]

Hi,

i have formula in data validation list like here:

=IF(AND(Vn_Input_HANA_Workload="BWoH";Vn_Input_HANA_Production="Yes");S_ConditionBWoHYes;IF(AND(Vn_Input_HANA_Workload="BWoH";Vn_Input_HANA_Production="No");S_ConditionBWoHNo;IF(AND(Vn_Input_HANA_Workload="SoH";Vn_Input_HANA_Production="Yes");S_ConditionSoHYes;S_ConditionSoHNo)))

Problem is that there is an entry limit!
How to avoid this?

Or workaround?

Best,
Jacek

 

[jaryszek]

Thank you RoryA!!!

I will use Evaluate better for my purposes

Best,
Jacek