I cannot make the formula work for subtraction.Any ideas?Thanks
=(A1-B1) Is that what you mean?
More like d=a-b
d ends up with ####### in it.
forgot to say its currency.
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.
Column is 10 wide & 2 Dec. places.
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.
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
Is there a reason why you are using a database for this? Try a spreadsheet, I think works has something like Excel I think...
works db is all i have.
This thread is now locked and can not be replied to.
OnePlus 5 review
50 best online Adobe XD tutorials
iPad Pro 10.5in (2017) review
Comment connecter un MacBook à une TV ?
© Copyright 2017 IDG UK. All Rights Reserved.