Thread: excel formula's
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default excel formula's

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