Math calculations

hi…



I am using professional grid.



I have a cell definition like this…

price[=(c9-c17)c14(1+(c15/100))(1-(c16/100))]



i know we have a setMathRound function but this will apply to the result of the calculation above.



What I really need is



price[=(c9-c17)
round(c14*(1+(c15/100))*(1-(c16/100)))]





See the round function above. Can I do that?



THanks

Peter

Try to use price[=(c9-c17)* Math.round(c14*(1+(c15/100))*(1-(c16/100)))]