Error Finding

Discuss the spreadsheet application

Error Finding

Postby rcrmonte3 » Tue Mar 12, 2019 6:21 pm

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?
OpenOffice 4.1.2 on windows 10
rcrmonte3
 
Posts: 11
Joined: Thu Dec 31, 2015 10:19 pm

Re: Error Finding

Postby RoryOF » Tue Mar 12, 2019 6:46 pm

Check that all your values are numbers - some may be text.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29559
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Error Finding

Postby RusselB » Tue Mar 12, 2019 10:24 pm

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.
OpenOffice 4.1.7 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
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.
User avatar
RusselB
Moderator
 
Posts: 5488
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests