Need to know how to write a calculation...
 

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

Need to know how to write a calculation...
 

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=546861

Need to know how to write a calculation...
 

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

Need to know how to write a calculation...
 

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=546861

Need to know how to write a calculation...
 

=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" wrote in message
...
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

Need to know how to write a calculation...
 

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

Regards.

Bill Ridgeway
Computer Solutions

"Ron Coderre" wrote in message
...
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