Thanks for the help in advance
Edit: Changed subject, was Error 506 Make your post understandable by others -- MrProgrammer, forum moderator |
Edit: Changed subject, was Error 506 Make your post understandable by others -- MrProgrammer, forum moderator |
My first tip:Vacation Register.xlsx
OpenOffice 4.1.6 on Windows 10
Code: Select all
=IF(COUNT(F5:G5) = 0;"";-SUM($F$5:F5) + SUM($G$5:G5))
Code: Select all
=IF(COUNT(F5:G5) = 0;""; SUM($G$5:G5) - SUM($F$5:F5))
Code: Select all
=IF(COUNT(F6:G6) = 0;""; SUM($G$5:G6) - SUM($F$5:F6))
The ODF is the first industrial standard for the electronic documents, and it was was developed for the long time compatibility:I don't know what standard ODF or OOXML formats are.
ejmasjr wrote: I am attaching spread sheet in question as I did not generate it and don't fully understand the formula so some outside help is needed.
We don't have that bogus Excel formula notation in OpenOffice. If you want to use formulas like the one in red, use Excel.Vacation Register.xlsx wrote:=IF(COUNT(tblData[[#this row],[debit (-)]:[credit (+)]])=0,"",-SUM(INDEX([debit (-)],1):tblData[[#this row],[debit (-)]])+SUM(INDEX([credit (+)],1):tblData[[#this row],[credit (+)]]))))