Formula Help PLease
 

See your post in public.excel.newusers



"Jennifer"
wrote in message
ng.com...
Hi,

Could someone tell me what's wrong with this formula?

=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

Thank you.

Formula Help PLease
 

Hi,

Could someone tell me what's wrong with this formula?

=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

Thank you.

Formula Help PLease
 

On Jun 29, 5:51*pm, Jennifer wrote:
Hi,

Could someone tell me what's wrong with this formula?

=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

Thank you.

Hi,

I assume that what you are trying to do is show a blank cell if C1=C2
but if C1 is greater than C2, or C2 is greater than C1, then you want
to show the value of C2 minus C1?

Currently you are showing C2-C1 within quotes which would return the
text string "C2-C1" rather than a value.

If my assumption is right then this formula should work
=if(C1=C2,"",C2-C1)

Hope that helps

Alan

Formula Help PLease
 

"Jennifer" wrote:
Could someone tell me what's wrong with this formula?
=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

Well, it would be helpful if __you__ told us what is wrong with it.

That is, what does it do that you don't like? And what result do you want
when C1=C2, C1<C2 and C2C1?

We are not mindreaders. But sometimes our wild-a.s.s guesses hit the mark.
Perhaps one of the following meets your needs:

=IF(C1=C2,"",C2-C1)

or

=IF(C1=C2,"",ABS(C2-C1))

(The latter assumes you have a typo in the last term of your IF expression,
among other mistakes.)

Formula Help PLease
 

Joe

Jennifer's problem was resolved in her other posting Jun 29th over in
excel.newusers group.

Message-ID: om


Gord


On Tue, 5 Jul 2011 16:00:00 -0700, "joeu2004" wrote:

"Jennifer" wrote:
Could someone tell me what's wrong with this formula?
=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

Well, it would be helpful if __you__ told us what is wrong with it.

That is, what does it do that you don't like? And what result do you want
when C1=C2, C1<C2 and C2C1?

We are not mindreaders. But sometimes our wild-a.s.s guesses hit the mark.
Perhaps one of the following meets your needs:

=IF(C1=C2,"",C2-C1)

or

=IF(C1=C2,"",ABS(C2-C1))

(The latter assumes you have a typo in the last term of your IF expression,
among other mistakes.)

Formula Help PLease
 

Here is the entire thread if you'e interested in the resolution.

http://tinyurl.com/6gsqesr


Gord

On Tue, 05 Jul 2011 16:36:51 -0700, Gord Dibben wrote:

Joe

Jennifer's problem was resolved in her other posting Jun 29th over in
excel.newusers group.

Message-ID: om


Gord


On Tue, 5 Jul 2011 16:00:00 -0700, "joeu2004" wrote:

"Jennifer" wrote:
Could someone tell me what's wrong with this formula?
=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

Well, it would be helpful if __you__ told us what is wrong with it.

That is, what does it do that you don't like? And what result do you want
when C1=C2, C1<C2 and C2C1?

We are not mindreaders. But sometimes our wild-a.s.s guesses hit the mark.
Perhaps one of the following meets your needs:

=IF(C1=C2,"",C2-C1)

or

=IF(C1=C2,"",ABS(C2-C1))

(The latter assumes you have a typo in the last term of your IF expression,
among other mistakes.)