Joined: 30 Aug 2004
Location: Egersund, Norway
|Posted: Tue Oct 04, 2011 8:10 am Post subject:
|It is as simple as A-B, or almost...
A few basic rules:
So if you have amounts entered in cells A1 and B1, enter this formula in C1: =B1-A1
- A calculation formula starts with the equals sign.
- Entered values are referenced by their position in the cell grid, specified by column letter and row number. (You can enter a reference into a formula by mouse click)
- To enter monetary values, type amount only (not currency). Otherwise it may be interpreted as text, and its computational value is not always what it seems...