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