Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Commissions
Help with the following.
Example: A1 = Renewal sale or increase value from Existing Business (5% Commissions) A2 = New Business from New Customers (7.5% Commissions) A3 = Reduce Sale from Existing Business (3% Commissions) Can someone help me with a formula that will return the correct commission value in cell A4 based on the commission structure above? Please note that all 3 cells will never be populated at the same time. Only 1 cell A1, A2, A3) will be populated per row. -- Sam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Commissions
hi,
try something like this.... =((A1*0.05)+(A2*0.07)+(A3*0.03)) regards FSt1 "Real Spice" wrote: Help with the following. Example: A1 = Renewal sale or increase value from Existing Business (5% Commissions) A2 = New Business from New Customers (7.5% Commissions) A3 = Reduce Sale from Existing Business (3% Commissions) Can someone help me with a formula that will return the correct commission value in cell A4 based on the commission structure above? Please note that all 3 cells will never be populated at the same time. Only 1 cell A1, A2, A3) will be populated per row. -- Sam |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Commissions
One way:
=SUMPRODUCT(A1:A3,{0.05,0.075,0.03})*A4 In article , Real Spice wrote: Help with the following. Example: A1 = Renewal sale or increase value from Existing Business (5% Commissions) A2 = New Business from New Customers (7.5% Commissions) A3 = Reduce Sale from Existing Business (3% Commissions) Can someone help me with a formula that will return the correct commission value in cell A4 based on the commission structure above? Please note that all 3 cells will never be populated at the same time. Only 1 cell A1, A2, A3) will be populated per row. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Commissions
Well if 'never' really means never then how about this:
=SUM((A1*0.05),(A2*0.075),(A3*0.03)) Hope that helps John "Real Spice" wrote in message ... Help with the following. Example: A1 = Renewal sale or increase value from Existing Business (5% Commissions) A2 = New Business from New Customers (7.5% Commissions) A3 = Reduce Sale from Existing Business (3% Commissions) Can someone help me with a formula that will return the correct commission value in cell A4 based on the commission structure above? Please note that all 3 cells will never be populated at the same time. Only 1 cell A1, A2, A3) will be populated per row. -- Sam |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Commissions
Oops, delete the *A4
=SUMPRODUCT(A1:A3,{0.05,0.075,0.03}) In article , JE McGimpsey wrote: One way: =SUMPRODUCT(A1:A3,{0.05,0.075,0.03})*A4 In article , Real Spice wrote: Help with the following. Example: A1 = Renewal sale or increase value from Existing Business (5% Commissions) A2 = New Business from New Customers (7.5% Commissions) A3 = Reduce Sale from Existing Business (3% Commissions) Can someone help me with a formula that will return the correct commission value in cell A4 based on the commission structure above? Please note that all 3 cells will never be populated at the same time. Only 1 cell A1, A2, A3) will be populated per row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating commissions | Excel Discussion (Misc queries) | |||
commissions by range | Excel Worksheet Functions | |||
calculating commissions for a range of values | Excel Worksheet Functions | |||
Calculating Commissions Macro | Excel Programming | |||
Calculating Commissions Macro | Excel Programming |