| View previous topic :: View next topic |
| Author |
Message |
keeperbay
Newbie
Joined: 13 Aug 2012
Posts: 1
|
 Posted: Mon Aug 13, 2012 1:42 pm Post subject: Can't figure out the formula and now I'm confusing myself |
 |
|
I'm normally good at this, but I have been at this for 4 hours now and I'm confusing myself.
I need the formula for price - expenses - %
I almost had it, but must have clicked the wrong option because now when I just add the price - expenses, I get a % --- what did I do wrong?
help! |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
|
| Posted: Mon Aug 13, 2012 5:54 pm Post subject: |
|
|
Assuming you want the percentage of the price the expenses are then:
Price Expense
100 ------- 25 ------ 25.00%
=B2/A2 and format the cell as Percent. |
|
| Back to top |
|
|
|
