-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Calculate the Maximum possible discount
- Thread starter asokaw
- Start date
Excel Facts
What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
pedro-egoli
Well-known Member
- Joined
- Apr 25, 2004
- Messages
- 1,217
- Office Version
- 2016
- Platform
- Windows
Not sure what you are after.
If you want to enter a price and see what percentage profit this might do
A1 = $100
B1 = any price you want to sell for
C1 = the percentage profit
Formula =SUM(B1-A1)/100
If you want to enter a price and see what percentage profit this might do
A1 = $100
B1 = any price you want to sell for
C1 = the percentage profit
Formula =SUM(B1-A1)/100
Upvote
0
Similar threads
- Replies
- 27
- Views
- 955
- Replies
- 1
- Views
- 165
- Replies
- 4
- Views
- 299
- Replies
- 2
- Views
- 303
