having total of formula automatically change

P

pnrple

HI - hoping to get some assistance here -

We have a spreadsheet that has the following:

Column 1 - Cost (Dealer Cost)
Coumn 2 - Mark up (using : =SUM(C7*0.05) )
Column 3 - Selling cost (=SUM(C7:D7) )

What we need to have happen at this point is
Colum 4 - Automatically rounds the amount to *.95 cost and then hav
it refigure the %of markup in Column 2

SO:

IF we have :

$42.95 $2.15 45.10 Need this to reformulate 45.10 to 44.95 an
then refigure $2.15 mark up cost to the correct %
 
J

J.E. McGimpsey

If I understand you correctly:

rounded value:

F7: =ROUND(E7+0.05,0)-0.05

refigured %:

G7: = (F7/C7)-1

format G7 as a percent.
 
Top