ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   please show me this formula format (https://www.excelbanter.com/new-users-excel/205659-please-show-me-formula-format.html)

Otto

please show me this formula format
 
lets give the numbers these destinations:
A1 = 125
A2 = 50

125 + 10% + 50 + 14% = total.

thanx

Roger Govier[_3_]

please show me this formula format
 
Hi Otto

not clear what you are after
=A1*(1+10%)+A2*(1+14%)
which is multiplying A1 x 10% and Multiplying 50 x 14% and totaling the two
to give 194.5

OR
=(A1*(1+10%)+50)*(1+14%)
which multiplies A1 x 10% then adds 50 and Multiplies that sum by 14% which
gives a total of 213.75
--
Regards
Roger Govier

"otto" wrote in message
...
lets give the numbers these destinations:
A1 = 125
A2 = 50

125 + 10% + 50 + 14% = total.

thanx



Otto

please show me this formula format
 
Hi Roger,

thank you very much it was the second answer.
thanx again for taking the time to answer.

regards,

otto

"Roger Govier" wrote:

Hi Otto

not clear what you are after
=A1*(1+10%)+A2*(1+14%)
which is multiplying A1 x 10% and Multiplying 50 x 14% and totaling the two
to give 194.5

OR
=(A1*(1+10%)+50)*(1+14%)
which multiplies A1 x 10% then adds 50 and Multiplies that sum by 14% which
gives a total of 213.75
--
Regards
Roger Govier

"otto" wrote in message
...
lets give the numbers these destinations:
A1 = 125
A2 = 50

125 + 10% + 50 + 14% = total.

thanx





All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com