# stuck for a formula

1. ## 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.

2. ## RE: 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.
>
>

3. ## RE: 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.
>
>

4. ## RE: 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.
> >
> >

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1