| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
show what % bottom # is of top # in excel
I have collumns of numbers. The bottom number is profit. The second from
bottom is cost. I would like to be able to show the percent of profit over cost in the cell below. profit/costX100. How do I do that? |
|
#2
|
|||
|
|||
|
You simply enter the formula. If, for example, your profit is in a12 and cost in
a11, enter =a12/a11*100 in a13. A better alternative is to use the formula =a12/a11 and format the cell as a percentage. -- Regards, Fred Please reply to newsgroup, not e-mail "priya" wrote in message ... I have collumns of numbers. The bottom number is profit. The second from bottom is cost. I would like to be able to show the percent of profit over cost in the cell below. profit/costX100. How do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show whole Table of Contents for Excel Help | Excel Discussion (Misc queries) | |||
| How do I show excel worksheets on a webpage when viewed by win98 . | Excel Discussion (Misc queries) | |||
| How do I set my Excel Chart to not show areas where I have no dat. | Charts and Charting in Excel | |||
| How do I change the thickness of a bottom boarder in Excel 2002? | Excel Discussion (Misc queries) | |||
| How do I show the last saved date in an Excel worksheet? | Excel Worksheet Functions | |||
Hybrid Mode
