Forum Discussion
Trying to use formulas in data validation
Hello all!
I have an issue with using formulas in Excels data validation. I want to validate user input by checking if D9 (input from user) is greater or equal than E9 and smaller or equal to F9. But when I'm trying to use the AND function it gives me the error message that excel belives that im not trying to write a formula. If I only use one of the conditions it workes fine. I have tried to find an solutions online without any luck so far.
Best regards
2 Replies
- The formula works OK for me. Are you using comma or semi-colon for your list separator?
- I was using comma, but tried semi-colon now and that worked. Thank you for replying
