Microsoft Works Database ?

  EARLR 13:37 22 Feb 2010
Locked

I cannot make the formula work for subtraction.

Any ideas?
Thanks

  wiz-king 13:45 22 Feb 2010

=(A1-B1) Is that what you mean?

  EARLR 13:53 22 Feb 2010

More like d=a-b

  EARLR 14:05 22 Feb 2010

d ends up with ####### in it.

  EARLR 14:06 22 Feb 2010

forgot to say its currency.

  wiz-king 14:21 22 Feb 2010

Ah, that is usually caused by the column not being wide enough to display the full number, also check the formating ie number of decimal places.

  EARLR 14:43 22 Feb 2010

Column is 10 wide & 2 Dec. places.

  wiz-king 14:53 22 Feb 2010

Try D1=A1-B1 using the values A=11.00 B=9.50 if that works (D=1.50) then you have a problem with your data.
If A or B are the result of calculations that could cause a problem.

  EARLR 15:34 22 Feb 2010

This is works database. you don't have choice as to what the collumns are named.
What I am trying to do is enter a starting DEPOSIT and subtract EXPENSES from it and put that in BALANCE and then keep subtracting expenses from that.

Never was any good at this.
Help

  Rahere 16:06 22 Feb 2010

Is there a reason why you are using a database for this? Try a spreadsheet, I think works has something like Excel I think...

  EARLR 16:09 22 Feb 2010

works db is all i have.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

HomePod review

Streaming : Netflix ou Amazon Prime Video ?