Edit: Changed subject, was Error Finding Make your post understandable by others -- MrProgrammer, forum moderator |
Row and column totals should match, but don't
Row and column totals should match, but don't
I have a row and a column with totals The totals should match, but mine don't. Is there any function or formula that I can use to find the error that causes the mismatch?
Last edited by MrProgrammer on Sun Aug 14, 2022 12:28 am, edited 1 time in total.
Reason: Changed subject
Reason: Changed subject
OpenOffice 4.1.2 on windows 10
Re: Error Finding
Check that all your values are numbers - some may be text.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Error Finding
The easiest way to do Rory's suggestion is to turn on Value Highlighting (View -> Value Highlighting or Ctrl+F8)
This is an on/off switch. When on your text entries will look black, your numbers will look blue and your formula results will look green
The actual colours may appear different from the above, but will be close.
This is an on/off switch. When on your text entries will look black, your numbers will look blue and your formula results will look green
The actual colours may appear different from the above, but will be close.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
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.