Problems with Calc

Discuss the spreadsheet application

Problems with Calc

Postby John17 » Sun Sep 16, 2018 11:25 am

What is wrong with this statement.
IF(C18+D18+E18+F18+G18=0;0;G18-(C18+D18+E18+F18)+H17)
When I use it I get a blank response even with values in some of the fields.
OpenOffice 4.1.3 on Windows 10
John17
 
Posts: 2
Joined: Tue Aug 21, 2018 9:44 am

Re: Problems with Calc

Postby Zizi64 » Sun Sep 16, 2018 11:29 am

Please upload a real spreadsheet file (in ODF format) here.
And you can try some more parentheses:
= IF(C18+D18+E18+F18+G18=0;0;G18-(C18+D18+E18+F18)+H17)
(maybe the G18=0 part gives a boolean result...)

=IF((C18+D18+E18+F18+G18)=0;0;G18-(C18+D18+E18+F18)+H17)
Last edited by Zizi64 on Sun Sep 16, 2018 2:56 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7162
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Problems with Calc

Postby Villeroy » Sun Sep 16, 2018 2:52 pm

If C18:G18 includes a text value you would get an error, so I think that C18+D18+E18+F18+G18 is not 0 because of decimal rounding issues.
Accounting in spreadsheets is a good reason to get fired.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25703
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Problems with Calc

Postby jrkrideau » Sun Sep 16, 2018 7:34 pm

Villeroy wrote:Accounting in spreadsheets is a good reason to get fired.


I once saw an advertisement for analysts for the Canadian Department of Finance with "experience in large, multi-sheet spreadsheet programs". I wonder if that explains our deficit?
AOO 4.1.5; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3537
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Calc

Who is online

Users browsing this forum: No registered users and 42 guests