Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.
I need a formula to say: IF H7 is x then I7 must be 1 or 2 OR if H7 is not blank then J7 must not be blank.
Basically they can use H7 to control field I7 with 1 or 2 OR they can use H7 to control J 7 to have a discount dollar amount. Is this possible?
2011-08-21 10:37:00
Tammy,did Bruce's solution work for you? Please let us know!
2011-08-17 08:40:00
Do you mean "x" as in the string literal for the contents of H7 so that if that character is in H7 it will ensure that I7 is either 1 or 2? In this case, H7 is not blank, so J7 also needs to have something in it as well. What you are saying in the first line does not match what you state in the second. You will need to clarify this before I can give you a fully qualified answer.