help please with simple formula

  • Thread starter Thread starter Scudo
  • Start date Start date
S

Scudo

F4 i have 0
H4 i have 6
J4 i have 1.12
The answer in N4 is 6 (good enough but would like to round to nearest No
which should be 7)
Formula used is =H4-F4*J4

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
 
Scudo said:
F4 i have 0
H4 i have 6
J4 i have 1.12
The answer in N4 is 6 (good enough but would like to round to nearest No
which should be 7)
Formula used is =H4-F4*J4

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
Click to expand...
the multiplcation takes place first thus for the first formula you
have 6- 0, zero times anything is zero. This applies to the second
formula also. Try (H7-F7)*J7

If you wnat it rounded try the Round function

gls858
 
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


 
Back
Top