setting maximums or minimums

I am setting up a spreadsheet to develop transportation quotes. I need the
following items if possible.

1. How do you get a cell to default to a number if the calculated cost falls
below the minimum cost?

2. How do you hvae a cell default to a maximum cost if the calculated cost
exceeds the maximum?

Example:
Column A shows a rate. There is a stipulated minimum of 140. There is a
maximum total cost of 475. How do you set up this formula?

Column A Column B Column C
Rate units cost
122.00 1 140.00

Do I understand you to want to multiply A1 * B1,
And never have the product fall below 140,
Or be greater then 475?

If that's the case, try this:

=MAX(140,MIN(475,A1*B1))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com> wrote in
message news:32383928-7EAF-412B-B7A8-15883A4306E3@microsoft.com...
> I am setting up a spreadsheet to develop transportation quotes. I need
the
> following items if possible.
>
> 1. How do you get a cell to default to a number if the calculated cost
falls
> below the minimum cost?
>
> 2. How do you hvae a cell default to a maximum cost if the calculated cost
> exceeds the maximum?
>
> Example:
> Column A shows a rate. There is a stipulated minimum of 140. There is a
> maximum total cost of 475. How do you set up this formula?
>
> Column A Column B Column C
> Rate units cost
> 122.00 1 140.00
>

yes that is correct. Thanks.

"Ragdyer" wrote:

> Do I understand you to want to multiply A1 * B1,
> And never have the product fall below 140,
> Or be greater then 475?
>
> If that's the case, try this:
>
> =MAX(140,MIN(475,A1*B1))
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
> "emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com> wrote in
> message news:32383928-7EAF-412B-B7A8-15883A4306E3@microsoft.com...
> > I am setting up a spreadsheet to develop transportation quotes. I need
> the
> > following items if possible.
> >
> > 1. How do you get a cell to default to a number if the calculated cost
> falls
> > below the minimum cost?
> >
> > 2. How do you hvae a cell default to a maximum cost if the calculated cost
> > exceeds the maximum?
> >
> > Example:
> > Column A shows a rate. There is a stipulated minimum of 140. There is a
> > maximum total cost of 475. How do you set up this formula?
> >
> > Column A Column B Column C
> > Rate units cost
> > 122.00 1 140.00
> >
>
>

Now what if I have a minimum but no maximum? what would that formula look
like?

"Ragdyer" wrote:

> Do I understand you to want to multiply A1 * B1,
> And never have the product fall below 140,
> Or be greater then 475?
>
> If that's the case, try this:
>
> =MAX(140,MIN(475,A1*B1))
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
> "emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com> wrote in
> message news:32383928-7EAF-412B-B7A8-15883A4306E3@microsoft.com...
> > I am setting up a spreadsheet to develop transportation quotes. I need
> the
> > following items if possible.
> >
> > 1. How do you get a cell to default to a number if the calculated cost
> falls
> > below the minimum cost?
> >
> > 2. How do you hvae a cell default to a maximum cost if the calculated cost
> > exceeds the maximum?
> >
> > Example:
> > Column A shows a rate. There is a stipulated minimum of 140. There is a
> > maximum total cost of 475. How do you set up this formula?
> >
> > Column A Column B Column C
> > Rate units cost
> > 122.00 1 140.00
> >
>
>

Try this:

=MAX(140,A1*B1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com> wrote in
message news:9BC34FE1-9341-4C7E-B967-7A1623D50EE2@microsoft.com...
> Now what if I have a minimum but no maximum? what would that formula look
> like?
>
> "Ragdyer" wrote:
>
> > Do I understand you to want to multiply A1 * B1,
> > And never have the product fall below 140,
> > Or be greater then 475?
> >
> > If that's the case, try this:
> >
> > =MAX(140,MIN(475,A1*B1))
> > --
> > HTH,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> >
> > "emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com> wrote
in
> > message news:32383928-7EAF-412B-B7A8-15883A4306E3@microsoft.com...
> > > I am setting up a spreadsheet to develop transportation quotes. I
need
> > the
> > > following items if possible.
> > >
> > > 1. How do you get a cell to default to a number if the calculated cost
> > falls
> > > below the minimum cost?
> > >
> > > 2. How do you hvae a cell default to a maximum cost if the calculated
cost
> > > exceeds the maximum?
> > >
> > > Example:
> > > Column A shows a rate. There is a stipulated minimum of 140. There is
a
> > > maximum total cost of 475. How do you set up this formula?
> > >
> > > Column A Column B Column C
> > > Rate units cost
> > > 122.00 1 140.00
> > >
> >
> >

Cool thanks for all the help!

"Ragdyer" wrote:

> Try this:
>
> =MAX(140,A1*B1)
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com> wrote in
> message news:9BC34FE1-9341-4C7E-B967-7A1623D50EE2@microsoft.com...
> > Now what if I have a minimum but no maximum? what would that formula look
> > like?
> >
> > "Ragdyer" wrote:
> >
> > > Do I understand you to want to multiply A1 * B1,
> > > And never have the product fall below 140,
> > > Or be greater then 475?
> > >
> > > If that's the case, try this:
> > >
> > > =MAX(140,MIN(475,A1*B1))
> > > --
> > > HTH,
> > >
> > > RD
> > >
> >
> > --------------------------------------------------------------------------
> -
> > > Please keep all correspondence within the NewsGroup, so all may benefit
> !
> >
> > --------------------------------------------------------------------------
> -
> > >
> > > "emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com> wrote
> in
> > > message news:32383928-7EAF-412B-B7A8-15883A4306E3@microsoft.com...
> > > > I am setting up a spreadsheet to develop transportation quotes. I
> need
> > > the
> > > > following items if possible.
> > > >
> > > > 1. How do you get a cell to default to a number if the calculated cost
> > > falls
> > > > below the minimum cost?
> > > >
> > > > 2. How do you hvae a cell default to a maximum cost if the calculated
> cost
> > > > exceeds the maximum?
> > > >
> > > > Example:
> > > > Column A shows a rate. There is a stipulated minimum of 140. There is
> a
> > > > maximum total cost of 475. How do you set up this formula?
> > > >
> > > > Column A Column B Column C
> > > > Rate units cost
> > > > 122.00 1 140.00
> > > >
> > >
> > >
>
>

Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com> wrote in
message news:10A823F9-7E08-4E61-AF35-D227EE744DBF@microsoft.com...
> Cool thanks for all the help!
>
> "Ragdyer" wrote:
>
> > Try this:
> >
> > =MAX(140,A1*B1)
> >
> > --
> > HTH,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> > "emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com> wrote
in
> > message news:9BC34FE1-9341-4C7E-B967-7A1623D50EE2@microsoft.com...
> > > Now what if I have a minimum but no maximum? what would that formula
look
> > > like?
> > >
> > > "Ragdyer" wrote:
> > >
> > > > Do I understand you to want to multiply A1 * B1,
> > > > And never have the product fall below 140,
> > > > Or be greater then 475?
> > > >
> > > > If that's the case, try this:
> > > >
> > > > =MAX(140,MIN(475,A1*B1))
> > > > --
> > > > HTH,
> > > >
> > > > RD
> > > >
> > >
> >
> --------------------------------------------------------------------------
> > -
> > > > Please keep all correspondence within the NewsGroup, so all may
benefit
> > !
> > >
> >
> --------------------------------------------------------------------------
> > -
> > > >
> > > > "emerald_dragonfly" <emeralddragonfly@discussions.microsoft.com>
wrote
> > in
> > > > message news:32383928-7EAF-412B-B7A8-15883A4306E3@microsoft.com...
> > > > > I am setting up a spreadsheet to develop transportation quotes. I
> > need
> > > > the
> > > > > following items if possible.
> > > > >
> > > > > 1. How do you get a cell to default to a number if the calculated
cost
> > > > falls
> > > > > below the minimum cost?
> > > > >
> > > > > 2. How do you hvae a cell default to a maximum cost if the
calculated
> > cost
> > > > > exceeds the maximum?
> > > > >
> > > > > Example:
> > > > > Column A shows a rate. There is a stipulated minimum of 140.
There is
> > a
> > > > > maximum total cost of 475. How do you set up this formula?
> > > > >
> > > > > Column A Column B Column C
> > > > > Rate units cost
> > > > > 122.00 1 140.00
> > > > >
> > > >
> > > >
> >
> >