I have a Data Validation formula that limits the amount a user may enter (based on another cell). This formula works great, but I need to add another criteria to the formula and I keep getting an error no matter what I try.
My current formula is "=sum(E12:K12)<=L7" (this formula limits the amount a user can enter if the sum is greater than the amount in "L7")....
However, I need to also add to this ... "=and(I11=0)" (meaning, they can't enter a value at all if "I11" is a value other than zero - regardless of the above formula).
Any suggestions as to how I might write this to make it work?
Thanks so much!
Bookmarks