Prev: macros button
Next: emailing worksheet
From: Joe on 1 May 2010 12:36
This is my Formula

=(a1-a2)

a1 = 37.5
a2 = 10

response should be -27.5

But response comes to 28 and under format the sample says 27.5 why ?

From: Gord Dibben on 1 May 2010 12:43
You either have a typo or don't understand arithmetic.

37.5 - 10 is 27.5

10 - 37.5 is -27.5

You will see 28 or -28 if formatted to no DP


Gord Dibben MS Excel MVP


On Sat, 1 May 2010 09:36:01 -0700, Joe <Joe(a)discussions.microsoft.com>
wrote:

>This is my Formula
>
> =(a1-a2)
>
>a1 = 37.5
>a2 = 10
>
>response should be -27.5
>
>But response comes to 28 and under format the sample says 27.5 why ?

From: Roger Govier on 1 May 2010 12:46
Hi Joe

The result should be 27.5, not -27.5 for the way tyou have expressed the
formula.
In this case, you don't need the parentheses around the cell references,
just =A1-A2 would suffice.

The reason you are seeing 28, is due to cell formatting.
Right click the cell>Format>Cell>Number>and chose 1 decimal place (or
whatever you require)
--
Regards
Roger Govier

Joe wrote:
> This is my Formula
>
> =(a1-a2)
>
> a1 = 37.5
> a2 = 10
>
> response should be -27.5
>
> But response comes to 28 and under format the sample says 27.5 why ?
>
From: JLatham on 1 May 2010 13:14
Sounds like that the formatting for the cell with the formula in it is simply
set up not to display any decimals, forcing 27.5 to display as 28.
As for "response should be -27.5" - no, not as you've shown it:
A1 = 37.5
A2 = 10
formula =(a1-a2)
is same as =(37.5 - 10)
is same as 27.5
to get -27.5 the formula would need to be =a2-a1 or =(a2-a1)


"Joe" wrote:

> This is my Formula
>
> =(a1-a2)
>
> a1 = 37.5
> a2 = 10
>
> response should be -27.5
>
> But response comes to 28 and under format the sample says 27.5 why ?
>
From: Billns on 1 May 2010 18:46
On 5/1/2010 10:14 AM, JLatham wrote:
> Sounds like that the formatting for the cell with the formula in it is simply
> set up not to display any decimals, forcing 27.5 to display as 28.
> As for "response should be -27.5" - no, not as you've shown it:
> A1 = 37.5
> A2 = 10
> formula =(a1-a2)
> is same as =(37.5 - 10)
> is same as 27.5
> to get -27.5 the formula would need to be =a2-a1 or =(a2-a1)
>
>
> "Joe" wrote:
>
>> This is my Formula
>>
>> =(a1-a2)
>>
>> a1 = 37.5
>> a2 = 10
>>
>> response should be -27.5
>>
>> But response comes to 28 and under format the sample says 27.5 why ?
>>
We all make missteaks!
I suspect Joe is banging his head against the monitor and saying "Doh!"

Bill
 | 
Pages: 1
Prev: macros button
Next: emailing worksheet