From: Carolan on
Need a formula - I know it's simply - just can't get it.
If A1 is greater than 5, then B1 = 5
If A1 is less than 5, B1 should equal the amount in A1
CarolAnn

From: Mike on
You dont say what you want to do if A1 = 5. Im assuming if it = 5 then return 5
=IF(A1>=5,5,A1)

"Carolan" wrote:

> Need a formula - I know it's simply - just can't get it.
> If A1 is greater than 5, then B1 = 5
> If A1 is less than 5, B1 should equal the amount in A1
> CarolAnn
>
From: T. Valko on
>If A1 is greater than 5...
>If A1 is less than 5...

What if A1 **IS** 5?

See if this does what you want.

=MIN(A1,5)

--
Biff
Microsoft Excel MVP


"Carolan" <Carolan(a)discussions.microsoft.com> wrote in message
news:19A21784-4A82-4C1E-AFA4-0B0921A1007C(a)microsoft.com...
> Need a formula - I know it's simply - just can't get it.
> If A1 is greater than 5, then B1 = 5
> If A1 is less than 5, B1 should equal the amount in A1
> CarolAnn
>


From: Carolan on
Sorry, I'm trying to say if what is in Column A is 5 or greater, then in
Column B the result should be 5. If what is in column A is less than 5,
Column B should equal the exact same amount

A B
1 5.5 5
2 4.2 4.2


"T. Valko" wrote:

> >If A1 is greater than 5...
> >If A1 is less than 5...
>
> What if A1 **IS** 5?
>
> See if this does what you want.
>
> =MIN(A1,5)
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Carolan" <Carolan(a)discussions.microsoft.com> wrote in message
> news:19A21784-4A82-4C1E-AFA4-0B0921A1007C(a)microsoft.com...
> > Need a formula - I know it's simply - just can't get it.
> > If A1 is greater than 5, then B1 = 5
> > If A1 is less than 5, B1 should equal the amount in A1
> > CarolAnn
> >
>
>
> .
>
From: T. Valko on
Ok, the formula I suggested will do what you want.

--
Biff
Microsoft Excel MVP


"Carolan" <Carolan(a)discussions.microsoft.com> wrote in message
news:B78D7726-9B45-41BE-8EBA-666B8ED5FDF4(a)microsoft.com...
> Sorry, I'm trying to say if what is in Column A is 5 or greater, then in
> Column B the result should be 5. If what is in column A is less than 5,
> Column B should equal the exact same amount
>
> A B
> 1 5.5 5
> 2 4.2 4.2
>
>
> "T. Valko" wrote:
>
>> >If A1 is greater than 5...
>> >If A1 is less than 5...
>>
>> What if A1 **IS** 5?
>>
>> See if this does what you want.
>>
>> =MIN(A1,5)
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Carolan" <Carolan(a)discussions.microsoft.com> wrote in message
>> news:19A21784-4A82-4C1E-AFA4-0B0921A1007C(a)microsoft.com...
>> > Need a formula - I know it's simply - just can't get it.
>> > If A1 is greater than 5, then B1 = 5
>> > If A1 is less than 5, B1 should equal the amount in A1
>> > CarolAnn
>> >
>>
>>
>> .
>>