stuck for a formula
 

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.

stuck for a formula
 

Let's say your pre-set credit is in cell A1, your return is in cell B1, then
in C1 enter:

=MIN(A1,B1)

This will return whichever value is lower.

HTH,
Elkar

"busta" wrote:

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.

stuck for a formula
 

Try something like this:

For
Col_B: Preset Limit
Col_C: Qty Returned
Col_D: Allowed Credit

D2: =MIN(+B2,+C2)


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"busta" wrote:

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.

stuck for a formula
 

I'm not sure if this applies to the OP's situation, but with that formula, if
one of the values is blank, it automatically returns the other.

***********
Regards,
Ron

XL2002, WinXP-Pro


"Elkar" wrote:

Let's say your pre-set credit is in cell A1, your return is in cell B1, then
in C1 enter:

=MIN(A1,B1)

This will return whichever value is lower.

HTH,
Elkar

"busta" wrote:

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.