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.
Problems with Calc
Problems with Calc
OpenOffice 4.1.3 on Windows 10
Re: Problems with Calc
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)
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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Re: Problems with Calc
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.
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Problems with Calc
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?Villeroy wrote: Accounting in spreadsheets is a good reason to get fired.
LibreOffice 7.3.7. 2; Ubuntu 22.04