IFAND Formula

[Paula]

Hi,

I want to make a formula which says the following.

If C2 > 0 and F2 >0, answer h2-e2 otherwise enter 0, I cant get the formula
to work, can you help please?

Many thanks

 

[Fred Smith]

Try it like this:

=if(and(c2>0,f2>0),h2-e2,0)

Regards,
Fred.

 

[CoolBusiness]

=if(and(c2>0,f2>0),h2-e2,0)

 

[joeu2004]

I want to make a formula which says the following.
If C2 > 0 and F2 >0, answer h2-e2 otherwise enter 0

One way:

=(H2-E2)*and(C2>0,F2>0)

 

[Dave Peterson]

And you could even use:

=(H2-E2)*(C2>0)*(F2>0)

The multiplication serves as an AND.

 

[Chip Pearson]

Try

=IF(AND(C2>0,F2>0),H2-E2,0)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)