very simple question, combining conditions...

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.
 
D

Domenic

Hi Patrick,

try,

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

Cheers!
 
P

Patrick

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?
 
R

RagDyer

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?
 

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

When there is a tie for "MAX" values... 6
A staying on schedule formula: 2
IF Statement 1
Conditional Formatting - 2 Worksheets one Named Range 5
Help with date formula 2
Combination to Two formulas with the Help of AND / OR / IF Functions 1
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1
FINDING AN EXACT MATCH ON 2 DIFFERENT SHEETS THEN EXECUTING A FORM 3

Top