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
|