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

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

One way:

=SUMPRODUCT(A1:A3,{0.05,0.075,0.03})*A4

In article <B4F48A84-AE20-455A-9A48-(E-Mail Removed)>,
Real Spice <(E-Mail Removed)> 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.

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" <(E-Mail Removed)> wrote in message
news:B4F48A84-AE20-455A-9A48-(E-Mail Removed)...
> 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

Oops, delete the *A4



=SUMPRODUCT(A1:A3,{0.05,0.075,0.03})

In article <jemcgimpsey-(E-Mail Removed)>,
JE McGimpsey <(E-Mail Removed)> wrote:

> One way:
>
> =SUMPRODUCT(A1:A3,{0.05,0.075,0.03})*A4
>
> In article <B4F48A84-AE20-455A-9A48-(E-Mail Removed)>,
> Real Spice <(E-Mail Removed)> 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.