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

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017