_______________
02-24-2022, 03:50 PM #1
Forum Contributor
IF OR Formula, Value doesn't match the data validation restriction defined for this cell
Hello,
I am attempting to use the following formula but I am getting the error "Value doesn't match the data validation restriction defined for this cell"
=IF[OR[C3="",H3="Yes"],0,F3*G3]Does anyone know the cause?
Thanks for any assistance.
Nick
02-24-2022, 03:53 PM #2
Re: IF OR Formula, Value doesn't match the data validation restriction defined for this ce
What value are you trying to enter into the cell? What cell is it in? What is in C3, H3, F3, and G3?
Jeff
| | |�| |�| |�| |�| | |:| | |�| |�|
Read the rules
Use code tags to [code]enclose your code![/code]02-24-2022, 03:56 PM #3
Re: IF OR Formula, Value doesn't match the data validation restriction defined for this ce
Hi Nick,
It sounds as though the cell you're trying to amend contains data validation restrictions. Select the cell[s] in question and go to Data -> Data Validation and see what restrictions are in place.
Regards,
Snook
02-24-2022, 03:57 PM #4
Re: IF OR Formula, Value doesn't match the data validation restriction defined for this ce
Well, I guess that would depend on what you are trying to get past the DV.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
02-24-2022, 04:02 PM #5
Forum Contributor
Re: IF OR Formula, Value doesn't match the data validation restriction defined for this ce
Thank you The_Snook, a Data Validation copied over from an adjacent cell that I didn't notice.
That fixed it.
02-24-2022, 04:08 PM #6
Re: IF OR Formula, Value doesn't match the data validation restriction defined for this ce
You're welcome mate, glad you've got it sorted.
Snook