How do I set a mimimum quotient value?

Is there a way to set the mimum value at 1 for all quotients?

Example:
A/B=C How do I get C to be a minimum of 1 if the quotient of A/B= less than 1?

Any help is greatly appreciated.

Robert

One way:

=MAX(1, A/B)

In article <[email protected]>,
Robert <[email protected]> wrote:

> Is there a way to set the mimum value at 1 for all quotients?
>
> Example:
> A/B=C How do I get C to be a minimum of 1 if the quotient of A/B= less than 1?
>
> Any help is greatly appreciated.
>
> Robert

Hi Robert,

=MAX(1,A1/B1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Robert" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to set the mimum value at 1 for all quotients?
>
> Example:
> A/B=C How do I get C to be a minimum of 1 if the quotient of A/B= less
> than 1?
>
> Any help is greatly appreciated.
>
> Robert

Is this what you're looking for:

IF(A1/B1<1,1,A1/B1)


"Robert" wrote:

> Is there a way to set the mimum value at 1 for all quotients?
>
> Example:
> A/B=C How do I get C to be a minimum of 1 if the quotient of A/B= less than 1?
>
> Any help is greatly appreciated.
>
> Robert

=MAX(A/B,1)

If you really mean quotient, try:

=MAX(INT(A/B),1)

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Is there a way to set the mimum value at 1 for all
quotients?
>
>Example:
>A/B=C How do I get C to be a minimum of 1 if the
quotient of A/B= less than 1?
>
>Any help is greatly appreciated.
>
>Robert
>.
>