Start Building Professional
Web Apps Today

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