Dear Scudo

I think it's now been answered, but remember in general that excel follows
mathematical conventions. eg BODMAS (easy to remember) -- formualae are resolved
in the strict order: * Brackets Of Divide Multiply Add Subtract*. So if you want
to add or subtract *before* multiplying/dividing then you must use brackets round
the items to first be added/subtracted.

eg 4 X 5-1 = 19 -- multiplies first then subtracts
but 4 X (5-1) = 16 -- does what's in the brackets first then multiplies



gls858 wrote:

F7 i have 0
H7 i have 6
J7 i have 2.24
The answer in N7 is still 6 ( it should be 12, double the one
above)
Formula used is =H7-F7*J7

just can`t work this out.

help please
thanks