![]() |
please show me this formula format
lets give the numbers these destinations:
A1 = 125 A2 = 50 125 + 10% + 50 + 14% = total. thanx |
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 |
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