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

B

Bob Phillips

Bit sparse on detail.

A guess

=A1/A2 and format as percentage.

--

HTH

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

Duck

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(E3>0,47%*E3,IF(E3<=2001,43%*E3<=$8001,39%*E3))
 
B

Bob Phillips

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)
 
Top