Page 1 of 1

Missing "difference/ subtract" function..

PostPosted: Thu Dec 20, 2007 4:22 pm
by fazzieng
I am looking for function which will subtract value from one cell from other..?
There`s no such function in list of math function in OO..
Where to get one..?

Re: Missing "difference/ subtract" function..

PostPosted: Thu Dec 20, 2007 4:39 pm
by huw
You don't need one. The minus symbol works.

If 10 is in cell A1, and 6 is in cell A2, type the following in cell A3
Code: Select all   Expand viewCollapse view
=A1-A2
and then press Enter. The formula will display 4 (in cell A3).