2 replies to this topic

[b00g3R]

alright i need to know whats the formula on how to get the % of this problem...

i thought it would be this =SUM(G18-G25+G15/G12)

it comes out to be like 4096.0% thats not what i want should be like 93.9%

this is what im trying to get 127-82=45 then + 1228 = 1273/1355 = 0.9394833

but with what i put it it gives me that 4096.0% or whateer it is

any help?

[rc69]

Order-of-ops. Parantheses, Multiply/Divide, Add/Subtract.
Try using more parantheses, you might be dividing first, and that would throw the result off (as well as the sum() function)

=(G18-G25+G15)/G12

Edited by rc69, 11 July 2006 - 07:01 PM.

[b00g3R]

thank you so much, it works. i guess i was thinking order of ops was add/subtract first thank you for the help and reminder..