Microsoft Works Database ?

  EARLR 13:37 22 Feb 10
Locked

I cannot make the formula work for subtraction.

Any ideas?
Thanks

  wiz-king 13:45 22 Feb 10

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

  EARLR 13:53 22 Feb 10

More like d=a-b

  EARLR 14:05 22 Feb 10

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

  EARLR 14:06 22 Feb 10

forgot to say its currency.

  wiz-king 14:21 22 Feb 10

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 10

Column is 10 wide & 2 Dec. places.

  wiz-king 14:53 22 Feb 10

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 10

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 10

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 10

works db is all i have.

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

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced