Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I have one cell that gives a year's expense allowance. Below it, I have a list of each invoice and the amount of each invoice. I would like the amount of each invoice to deduct from the above expense allowance so at any time, a user can see exactly how much is left in the expense allowance. I can do one invoice just using the subtraction in one cell (=B2-D4 where the B2 is the expense allowance and the D4 is the invoice total), but I can't do a list of them. Thanks for any help, Siobhan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |