Quote:
Originally Posted by Wilco
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?