That is not what OP posted as the formula used.

=A1 + A2/10 answer comes back as 150

I guess the typo was in the formula, not the result.


Gord

On Wed, 12 Sep 2007 07:24:15 -0700, ilia wrote:

=A2+A1/10 would give you 150.

On Sep 11, 1:16 pm, Gord Dibben <gorddibbATshawDOTca wrote:
What answer do you expect?

=A1+A2/10 gives me 510

=(A1+A2)/10 returns 60

I have no idea why you would ever get 150 out of your formula unless that is a
typo and you meant 510

Gord Dibben MS Excel MVP



On Tue, 11 Sep 2007 10:02:03 -0700, TDF wrote:
when i add 2 numbers then divide by a number it's answer is wrong, why

example: when i add 500 = A1
100 = A2
=A1 + A2/10 answer comes back as 150- Hide quoted text -

- Show quoted text -