I am using this formula for data validation
If C31 = "DIRECT BUSINESS", I Can only enter 0 in C34. this bit works fine.
However if C31 does not contain "DIRECT BUSINESS", I want to limit C34 to to a maximum of 25 this bit does not work.
Any ideas please.
I have also tried the following
=OR(AND(C31="DIRECTBUSINESS",C34=0),AND(C31<>"DIRE CT BUSINESS",C34<25))
But they all allow me to enter more than 25 in C34 If C31 does not contain "Direct Business"