Hi, I am trying to combine 2 AND formulas so that I can sa if an error.
I need to be in this example to highlight one of two things:-
If the box "Y" for sign up, and there is a value in A2, text saying no error
If the box is "N", and there is no value in A2, text saying no error
Anything else (i.e ticked yes but no data before, or ticked no but data before), text saying error
Solved by K. J. in 26 mins