| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 104517 | 2009-10-30 02:55:00 | Excel spreadsheet calculations | asdex (1488) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 825499 | 2009-10-30 02:55:00 | Hi I am making a spreadsheet with coloums for total items then removed items then balance which would be transfered to the next row for a total. This is to keep track of stock used. I have 10 different items so will use 10 worksheets and then a front sheet to show running total from all pages. I can't get the calculation right so the total is transfered without the numbers repeating down the whole row. Can someone tell me how to do this? Thanks |
asdex (1488) | ||
| 825500 | 2009-10-30 05:35:00 | I did this to keep a running total of deposits in column D withdrawals in column C with the running balance in column E If there is nothing in C or D 0 is used in column E and then I set the spreadsheet to not display zeroes. If you dont wish to turn off the zero dsiplay you can substitute "" (2 double quotes). =IF(OR(C1908>0,D1908>0),E1907-C1908+D1908,0) |
TeejayR (4271) | ||
| 825501 | 2009-11-09 23:29:00 | Thanks very much, I'll give it a try. Cheers |
asdex (1488) | ||
| 1 | |||||