having total of formula automatically change

  • Thread starter Thread starter pnrple
  • Start date Start date
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 %
 
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.
 
Back
Top