| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
please show me this formula format
lets give the numbers these destinations:
A1 = 125 A2 = 50 125 + 10% + 50 + 14% = total. thanx |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Control + Grave accent doesn't show formula result, format is gene | Excel Worksheet Functions | |||
| Date format shows on formula bar, 5 digit numbers show in row | Excel Discussion (Misc queries) | |||
| Why does formula show rather than results (not in text format) | Excel Worksheet Functions | |||
| Set conditional format to show when a sell contain a formula | Excel Discussion (Misc queries) | |||
| Show format in formula bar | Excel Discussion (Misc queries) | |||
Hybrid Mode
