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.
 
Hi Patrick,

try,

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

Cheers!
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format Q 4
When there is a tie for "MAX" values... 6
A staying on schedule formula: 2
Countif Help 3
Conditional Formatting - 2 Worksheets one Named Range 5
Help with date formula 2
IF Statement 1
Combination to Two formulas with the Help of AND / OR / IF Functions 1

Back
Top