OOo Calc

Toonses82 · 10-14-2006, 02:15 AM

I have a simple problem that I can't seem to figure out. I'm using an Open Office Calc Spreadsheet for my budget and I need to make a particular cell show the difference of two other cells (Cell 1 minus Cell 2). I've been able to figure out how to get the sum of certain cells and the product (multiplication) of certain cells, but not the difference. Is there a way to do this?

Toonses82 · 10-14-2006, 02:27 AM

Ok, so of course the minute I ask a question on the forum, I then find the answer on my own. Oh well. Thanks for reading at least and hopefully this post can serve as a useful resource for someone else.

If you want a cell to show the difference between L17 and L16 as mentioned in the previous post, in the cell, enter the equation "=L17-L16" (without the quotes) and that's it. Seems pretty self explanatory, but I had a hard time finding it for myself. This website proved useful:
http://www.tutorialsforopenoffice.or...User_Calc.html