Re: How to determine difference?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: RW (rw2rw_at_hotmail.com)
Date: 01/21/05 

Date: Thu, 20 Jan 2005 23:22:41 -0600

I think JE Mcgimpsey's answer was correct:
    =B1-A1
When A1=100 and B1=105, B1-A1= 5;
when A1=100 and B1=95, B1-A1= -5,
exactly what you asked for.
Maybe there's more to your question?

(By the way, this is my first reply to a newsgroup. I hoped it works.)
Ray W

"Fionavar" <fionavarXXX@perlucidus.XXX.net> wrote in message
news:10v10asfh6roo24@corp.supernews.com...
> Thanks for the ideas! Both of those only work when the difference is an
> increase - it does not register the negative correctly. Am I explaining
> this clearly? I may just have to manually switch the number when I know it
> may be a negative, unless there is a way to do this?
> "CarlosAntenna" <carlos@antenna.com> wrote in message
> news:%23kZQvQ2$EHA.2572@tk2msftngp13.phx.gbl...
>> =ABS(a1-b1)
>>
>> Carlos
>>
>> "Fionavar" <fionavarXXX@perlucidus.XXX.net> wrote in message
>> news:10v0ggoi91s4c57@corp.supernews.com...
>>> If I have a cell that is 100 and another cell in which I want to
>>> demonstrate the difference - how do I set this up? The problem is that
>>> at the moment if I use a simple a1-b1 I get a negative number if b is
>>> larger. What I want is it to indicate the change as a +/-. So if A is
>>> 100 and B is 105, I would like to cell to indicate 5. If B is 95 -
>>> then -5 - does this make sense? Any help is MUCH appreciated.
>>>
>>
>>
>
>

Relevant Pages

  • Re: How to determine difference?
    ... increase - it does not register the negative correctly. ... Am I explaining this ... >> If I have a cell that is 100 and another cell in which I want to ...
    (microsoft.public.excel)
  • Re: [opensuse] Internet domain names with international characters (idn)
    ... Carlos E. R. wrote: ... So if I read the implications correctly, you may be able to register ... spoof domains on .com and the whois will spoof you as well. ...
    (SuSE)
  • Re: Problem with Registering filter on windows mobile
    ... I am also facing exactly the same issue as Suresh. ... resolve this issue. ... I am explaining the issue again: ... The same is the case with any directshow filter I try to register on ...
    (microsoft.public.windowsce.app.development)
  • Re: Squeaky Guitars
    ... at my age I didn't even notice the difference. ... I had a young teen girl explaining to me, an old, old man (really ... It took a second for it to register on her that I was putting her ... Sadly, this bright-eyed, red-headed little girl is now a dumpy, ...
    (rec.music.makers.guitar.acoustic)
  • Re: Yankees Sign Santana
    ... winter meetings are barely under way and already somebody's got some ... explaining to do. ... sounded like the voice on the other end said, 'I want Carlos Santana,'" ... and the best part is that the yankees get to keep melky cabrera. ...
    (rec.music.artists.springsteen)