How to calculate and then show up as a percent?
 

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?


--
Amuse
------------------------------------------------------------------------
Amuse's Profile: http://www.excelforum.com/member.php...o&userid=25086
View this thread: http://www.excelforum.com/showthread...hreadid=385986

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.

--
Regards,
Tom Ogilvy

"Amuse" wrote in
message ...

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?


--
Amuse
------------------------------------------------------------------------
Amuse's Profile:
http://www.excelforum.com/member.php...o&userid=25086
View this thread: http://www.excelforum.com/showthread...hreadid=385986