hi,
I have a spreadsheet where a stockist returns what he does not sell
but is only allowed a pre-set amount of credit (the credit varies from
day to day), When I input the stockists' total returned amount for
each day I want the spreadsheet to work out the amount that he is
actually allowed based on the amount of credit I have pre-set for each
day. I.E
Pre-set Credit Stockist returned Allowed credit
Monday - 2 10 2
Tuesday - 3 12 3
Wednesday - 4 1 1
Thursday - 3 0 0
Friday - 6 2 2
I have had trouble writing a formula to work out the allowed credit,
Can anyone help? The Values are not currency values.
Thanks if you can help.
Bookmarks