Hi
I would like to prevent users from being enter specific values through data validation.
The current formula is “=OR(AND(E2="Reference Pressure",OR(J2<0,J2="STD")),AND(E2="Flame Transmission",J2>0))”
I would like to expand on this so that when “Reference Pressure” is selected in column E, you can either enter “STD” or a value between -20 °C to -60 ° C (Not possible to enter say -10 °C for example)
Similarly if “Flame transmission” is selected in column D you can either enter “STD” or a value between 60 °C to 220 °C
Thanks!
Bookmarks