IFAND Formula
 

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

IFAND Formula
 

Try it like this:

=if(and(c20,f20),h2-e2,0)

Regards,
Fred.

"Paula" wrote in message
...
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

IFAND Formula
 

=if(and(c20,f20),h2-e2,0)

"Paula" wrote:

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

IFAND Formula
 

On Feb 19, 7:37*am, Paula wrote:
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(C20,F20)

IFAND Formula
 

And you could even use:

=(H2-E2)*(C20)*(F20)

The multiplication serves as an AND.

joeu2004 wrote:

On Feb 19, 7:37 am, Paula wrote:
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(C20,F20)

--

Dave Peterson

IFAND Formula
 

Try

=IF(AND(C20,F20),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)

On Thu, 19 Feb 2009 07:37:28 -0800, Paula
wrote:

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