How to calculate and then show up as a percent?

A

Amuse

I'm trying to make a formula for calculating Return on Investment.
Which is equal to (total revenue-total expense)/my investment
My formula right now is =(D18/D4)*100
D18 is (total revenue-total expense)
D4 is my investment

But the output is in $ format
How do I make it as a percent?
 
T

Tom Ogilvy

change
=(D18/D4)*100
to
=(D18/D4)

click on the cell with the formula. Do Format=>Cells, go to the number tab,
choose Percentage. Choose the number of decimal points you want to display.
(you should see a sample of your formatted output in the sample box of the
dialog). No click OK>

That should do it.
 
Top