Page 1 of 1

Calc numbers (rounding)

PostPosted: Thu May 16, 2019 12:24 am
by elliot13458
I was attempting to calculate the lotsize based on balance

would the forumula be correct for this.

=A5*0.00009

it came out to 0.05 for 500 usd balance which is 5% is this the right formula. i dragged it down to apply to the other cells. this is on profit loss-2mod2.ods file

Re: calc numbers

PostPosted: Thu May 16, 2019 1:55 am
by Villeroy
Turn off "Precision as shown" in Tools>Options>Calc>Calculation.

Re: calc numbers

PostPosted: Thu May 16, 2019 2:14 am
by elliot13458
how would I get it to round up 0.045 lots to 0.05 lots?

Re: calc numbers

PostPosted: Thu May 16, 2019 3:01 am
by RusselB
Use the ROUND function with the 2nd parameter as 2 for 2 decimal places displayed.