Excel - IFAND Formula

Asked By Paul on 19-Feb-09 10:37 AM
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 replied on 19-Feb-09 10:41 AM
Try it like this:

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

Regards,
Fred.
CoolBusines replied on 19-Feb-09 10:43 AM
=if(and(c2>0,f2>0),h2-e2,0)
joeu2004 replied on 21-Feb-09 05:49 AM
One way:

=3D(H2-E2)*and(C2>0,F2>0)
Dave Peterson replied on 19-Feb-09 11:22 AM
And you could even use:

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

The multiplication serves as an AND.


--

Dave Peterson
Chip Pearson replied on 19-Feb-09 11:24 AM
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)