M.K Cleaners.co.uk
Well-known member
- Messages
- 4,241
I cant send it thorugh a PM for some reason and I dont have your e-mail.
Ignore the first sheet names ''Kelty'' fo to the ''Dunfermline'' marked sheet.
The only formula thats wrong is the one at the bottom ''Total OUTSTANDING Per Week Commencing'' it tells you how much you can make, where as I want it to tell me how much is due in. The only thing that stopping it is when I put a ''/ ''in. It wont recognise it so ignores it. Which leads to it mucking up. If you were not to put the ''/'' then I am under the impression it works... im fussy though so its no good for me yet.
Sheet2.xls
Ignore the first sheet names ''Kelty'' fo to the ''Dunfermline'' marked sheet.
The only formula thats wrong is the one at the bottom ''Total OUTSTANDING Per Week Commencing'' it tells you how much you can make, where as I want it to tell me how much is due in. The only thing that stopping it is when I put a ''/ ''in. It wont recognise it so ignores it. Which leads to it mucking up. If you were not to put the ''/'' then I am under the impression it works... im fussy though so its no good for me yet.
Sheet2.xls
