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