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
Calc numbers (rounding)
-
elliot13458
- Posts: 10
- Joined: Sun May 13, 2018 10:59 pm
Calc numbers (rounding)
- Attachments
-
- test.ods
- (9.27 KiB) Downloaded 78 times
-
- profit loss 2-mod2.ods
- (18.99 KiB) Downloaded 83 times
Openoffice 4.1.1 on windows 7
Re: calc numbers
Turn off "Precision as shown" in Tools>Options>Calc>Calculation.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
elliot13458
- Posts: 10
- Joined: Sun May 13, 2018 10:59 pm
Re: calc numbers
how would I get it to round up 0.045 lots to 0.05 lots?
Openoffice 4.1.1 on windows 7
Re: calc numbers
Use the ROUND function with the 2nd parameter as 2 for 2 decimal places displayed.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.