Need to know how to write a calculation...

[Mary A Perez]

I need to take the $ amount in b10 & mulitply it my 20% but tell the formula
that if the result is >$2,700 just put $2,700 in the answer.
Can someone write this out for me?
Thank you

[mrice]

=if(b10*1.2>2700,2700,b10*1.2)

[mrice]

=if(b10*1.2>2700,2700,b10*1.2)

[Ron Coderre]

Try something like this:

=MIN(B10*20%,2700)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Mary A Perez" wrote:

> I need to take the $ amount in b10 & mulitply it my 20% but tell the formula
> that if the result is >$2,700 just put $2,700 in the answer.
> Can someone write this out for me?
> Thank you

[Bill Ridgeway]

That works just as well AND is shorter than my suggestion.

Regards.

Bill Ridgeway
Computer Solutions

"Ron Coderre" <ronREMOVETHIScoderre@bigfoot.com> wrote in message
news:DCEA0AD7-59D8-4021-9A69-FB87B73D17AC@microsoft.com...
> Try something like this:
>
> =MIN(B10*20%,2700)
>
> Does that help?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "Mary A Perez" wrote:
>
>> I need to take the $ amount in b10 & mulitply it my 20% but tell the
>> formula
>> that if the result is >$2,700 just put $2,700 in the answer.
>> Can someone write this out for me?
>> Thank you

[Bill Ridgeway]

=IF(B10*120%>2700,2700,B10*120%)

I've assumed you want the base increased by 20% and not 20%of the base
price.

Regards.

Bill Ridgeway
Computer Solutions

"Mary A Perez" <MaryAPerez@discussions.microsoft.com> wrote in message
news:9A59D0D1-8641-47EE-86DD-3761CE95B0FB@microsoft.com...
>I need to take the $ amount in b10 & mulitply it my 20% but tell the
>formula
> that if the result is >$2,700 just put $2,700 in the answer.
> Can someone write this out for me?
> Thank you