What forumla can I use to control the content of one cell based on another in Excel?

Tammy August 15, 2011
Whatsapp Pinterest

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?

  1. Tina
    August 21, 2011 at 10:37 am


    did Bruce's solution work for you? Please let us know!

  2. Bruce Epper
    August 17, 2011 at 8:40 am

    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.