| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Share write protection fails | Excel Discussion (Misc queries) | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
