Calc numbers (rounding)

Discuss the spreadsheet application

Calc numbers (rounding)

Postby elliot13458 » Thu May 16, 2019 12:24 am

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
Attachments
test.ods
(9.27 KiB) Downloaded 12 times
profit loss 2-mod2.ods
(18.99 KiB) Downloaded 11 times
Openoffice 4.1.1 on windows 7
elliot13458
 
Posts: 10
Joined: Sun May 13, 2018 10:59 pm

Re: calc numbers

Postby Villeroy » Thu May 16, 2019 1:55 am

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: calc numbers

Postby elliot13458 » Thu May 16, 2019 2:14 am

how would I get it to round up 0.045 lots to 0.05 lots?
Openoffice 4.1.1 on windows 7
elliot13458
 
Posts: 10
Joined: Sun May 13, 2018 10:59 pm

Re: calc numbers

Postby RusselB » Thu May 16, 2019 3:01 am

Use the ROUND function with the 2nd parameter as 2 for 2 decimal places displayed.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
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.
User avatar
RusselB
Moderator
 
Posts: 5391
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests