Thread: formula needed
View Single Post
  #3   Report Post  
Carmellajade Carmellajade is offline
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by Wilco View Post
Hi Carmellajade

If I understand your query correctly the formula your are looking for is correct
=E/F
The possible problem is perhaps your cell format

Select cell containing this formula and change the format of the cell to display the formula in percentage

right click cell
Select 'Format Cells'
Select the tab 'Number'
and select Percentage

Here you can also change the decimal places


This will then disclose the the result in % as required


Thats brilliant! thank you

Just one other question....
How do I set the formula so that it does this percentage automatically on the cell as opposed to me typing in E4/F4, and then E5/F5 and so on?