I need a formmula to gives a % split for dif. $ amounts
 

I need a formmula to gives a % split for dif. $ amounts
 

Bit sparse on detail.

A guess

=A1/A2 and format as percentage.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Duck" wrote in message
...

I need a formmula to gives a % split for dif. $ amounts
 

Im tying to put the retail price in E3 and calculate the % in F3 and G3
$0 to $2000 53% 47% split $2001 to $8000 57% 43% split $8000 up 61% 39% split
So it will recognize each price break.
Can this be done?

This only will come up with the first percentage break.
=IF(E30,47%*E3,IF(E3<=2001,43%*E3<=$8001,39%*E3))


"Bob Phillips" wrote:

Bit sparse on detail.

A guess

=A1/A2 and format as percentage.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Duck" wrote in message
...

I need a formmula to gives a % split for dif. $ amounts
 

F3: =E3*VLOOKUP(E3,{0,0.53;2001,0.57;8001,0.61},2)
G3: = E3-F3

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Duck" wrote in message
...
I'm tying to put the retail price in E3 and calculate the % in F3 and G3
$0 to $2000 53% 47% split $2001 to $8000 57% 43% split $8000 up 61% 39%
split
So it will recognize each price break.
Can this be done?

This only will come up with the first percentage break.
=IF(E30,47%*E3,IF(E3<=2001,43%*E3<=$8001,39%*E3))


"Bob Phillips" wrote:

Bit sparse on detail.

A guess

=A1/A2 and format as percentage.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Duck" wrote in message
...