Can someone help me please

  • Thread starter Thread starter cnino
  • Start date Start date
C

cnino

Hello guys maybe you guys can help me with this project.

This is my problem I have a worksheet in which I have the cost of th
item the retail value and the next cell I woul like to figure out th
percentage increase. Can someone help me with this.

this is how it looks on my excell sheet

Cost Retail Percentage
100 140.00 ?


I want that by me increasing the retail the percentage will increase o
decrease automatically.

My email is (e-mail address removed)

thank
 
It can be as simple as

=(B1-A1)/A1

and format as percnetage

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
*cnino*

One way:

Cost in A1
Retail in B1

In C1:

=(B1-A1)/(A1)*100

George Gee



*cnino* has posted this message:
 
Back
Top