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)))]