Formula Help PLease

[Jim Cone]

See your post in public.excel.newusers



"Jennifer" <[email protected]>
wrote in message
news:[email protected]...

 

[Jennifer]

Hi,

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

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

Thank you.

 

[Alan Baybut]

Hi,

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

=IF((C1=C2),"",OR(IF((C1>C2),"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

 

[joeu2004]

Could someone tell me what's wrong with this formula?
=IF((C1=C2),"",OR(IF((C1>C2),"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 C2>C1?

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

 

[Gord Dibben]

Joe

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

Message-ID: <[email protected]>


Gord

 

[Gord Dibben]

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

http://tinyurl.com/6gsqesr


Gord