Ask Your Question
0

Help with LibreOffice Calc Equation [closed]

asked 2017-01-18 21:31:54 +0100

jridgers gravatar image

updated 2020-09-21 01:33:03 +0100

Alex Kemp gravatar image

I want to put this equation into LibreCalc:

= total spend ÷ total sales x 100

I created the formula of =SUM(A16/D16)*100

But I get 7957.xxx insteqd of the 79.57 that I'm expecting. What am I doing wrong in the formula I created?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by jridgers
close date 2017-01-19 06:08:27.594502

2 Answers

Sort by » oldest newest most voted
1

answered 2017-01-19 00:27:20 +0100

karolus gravatar image

there's nothing to SUM … avoid this useless stuff

=A16/D16*100
edit flag offensive delete link more

Comments

Thanks. I was over thinking it.

jridgers gravatar imagejridgers ( 2017-01-19 06:07:49 +0100 )edit

for me =A16/D16*100, =(A16/D16)*100 and =SUM(A16/D16)*100 all produce the same result, thus i doubt the 'SUM' was the error here, more likely cell formatting or 'late apply of format change' (not evaluated until first edit or 'touch' of value) stepped in ...

newbie-02 gravatar imagenewbie-02 ( 2020-09-22 15:08:46 +0100 )edit
1

answered 2017-01-18 21:35:26 +0100

Possibly you used Percent as cell format? If so, then you didn't need that 100.

Btw, the proper name is LibreOffice Calc.

edit flag offensive delete link more

Comments

Thanks, noted.

jridgers gravatar imagejridgers ( 2017-01-19 06:08:08 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2017-01-18 21:31:54 +0100

Seen: 51 times

Last updated: Sep 21