very simple question, combining conditions...

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

I have 2 simple formulas below but I am not sure how to
combine the two ie: I want both conditions to be met
before printing result...
=IF(Sheet1!I7>Sheet1!D7,Sheet1!C7,"")
=IF(Sheet1!J7>Sheet1!H7,Sheet1!C7,"")

I appreciate your assistance with this.
 
Thanks for the tip however when the criteria is not met
the word "False" appears. I would prefer that the cell
remains empty if both conditions are not met. Is this
possible?
 
Try this:

=IF(AND(Sheet1!J7>Sheet1!H7,Sheet1!I7>Sheet1!D7),Sheet1!C7,"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Thanks for the tip however when the criteria is not met
the word "False" appears. I would prefer that the cell
remains empty if both conditions are not met. Is this
possible?
 
Back
Top