
Signature
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Hi there,
That might work but the logic doesn't seem right...I need an IF-ELSE
type result, where if there is something in D2, A2 = B2-C2, but if
there is nothing in D2, A2=B2. Make sense? I don't see quite how this
will work but again, I haven't had time to try it yet today.
> New is in Column A
> Current is in Column B
[quoted text clipped - 28 lines]
> > Thanks,
> > Mike
Ragdyer - 21 Jul 2006 22:13 GMT
OK, you didn't stipulate that A2 should equal B2 if D2 was empty.
So, try this instead:
=B2-(D2<>"")*C2

Signature
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> Hi there,
>
[quoted text clipped - 35 lines]
>> > Thanks,
>> > Mike