How to calculate and then show up as a percent?

  • Thread starter Thread starter Amuse
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas Still Not Working 5
compounding years and months 1
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Payment calculation 1
Calculating weighted average of Percent Change 0
Profit and Loss different sections "Excel P&L template" 3
Adding Days and Hours 8
Fill Series only changing one input 2

Back
Top