Thread: excel formula's
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default excel formula's

I don't undertstand why you get 150 I assume it's a type for 510 but to get
the correct answer you must force precedence with brackets:-

=(A1+A2)/10 returns 60 for the values you give whereas

=A1+A2/10 returns 510 bevcause the division is done first.

Mike

"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