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

Tammy August 15, 2011
Pinterest Stumbleupon Whatsapp

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?

Ads by Google