Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|