Formula within a table

  • Thread starter Thread starter Dragon
  • Start date Start date
D

Dragon

I'm trying to get a formula within a table.
I have 3 columns one with planned qty, one with actual qty, and one with the
total qty out of stock for the order (TOS). all cells are formatted as
numbers.
I want to have a fourth column that adds the actual qty and TOS then
subtracts the planned qty.
I have an excel spreadsheet set up with an if statement that retuens either
Balance, or Try Again.
If it's possible to have it return the text, fantastic, but even a 0 or
whatever qty it is off would be ok too.

example:
planned: 1800
actual: 1750
TOS: 50
result: Balance

Thanks,
Dragon
 
You can create a query with the calculations based your fields.
e.g.
FIELDNAME:[actual]+[tos]-[planned]

You can also do if statements in a query like in excel by using IIF instead
of IF.

Then if you still need a table, run a make table query.
 
I'm trying to get a formula within a table.
I have 3 columns one with planned qty, one with actual qty, and one with the
total qty out of stock for the order (TOS). all cells are formatted as
numbers.
I want to have a fourth column that adds the actual qty and TOS then
subtracts the planned qty.
I have an excel spreadsheet set up with an if statement that retuens either
Balance, or Try Again.
If it's possible to have it return the text, fantastic, but even a 0 or
whatever qty it is off would be ok too.

example:
planned: 1800
actual: 1750
TOS: 50
result: Balance

Thanks,
Dragon
Click to expand...

You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using.
I would suggest you include your Windows and Office version number in
your message. It might make a difference.
 
Back
Top