Hey Guys,
I have a quick question about Excel for you all. I've been trying to figure this out myself but I figure it will be easier and faster if I ask you all.
Let's say in Excel I have columns with different monetary value projecting profit for a company. Is there a fast way using excel, where I can use a formula or something to increase each number by 15% instead of calculating and changing it manually??
Thanks!
| +152 | How to stop feeling like shit for not making it in IB? | 57 | 4h | |
| +115 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 58 | 3h | |
| +80 | Updated LA Banking Scene (2024) | 57 | 1h | |
| +38 | Ranking banks that went under | 20 | 8h | |
| +34 | Burnt Out M&A ASO | 18 | 6h | |
| +32 | A strategy for SA applicants late to the game like myself | 15 | 15h | |
| +29 | Relevance of A-Levels for U.K. London recruiting | 21 | 21h | |
| +26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
| +26 | Intern Ettiquette | 4 | 17h | |
| +23 | What are hours like at BBs in London? | 47 | 17h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
oh wow
just find a new area... pick the top right most cell, make formula (=cell#*1.15) and then autofill right and down to get all of them at the new value
get. the. fuck. out.
type 15% in another cell and then multiply your value by 1+15% cell, hit f4 to fix the 15% cell, then hit enter copy ctrl+c the result, paste with alt+e+s+v that cell across the row
try again
LOL
Go to one of the cells, press F2 to access the cell contents and multiply the number by 1.15 and hit enter. Copy this cell, select the entire column going down using the Ctrl and Shift keys, then hit Alt E S F to copy the 15% increase formula to each cell. Hope this helps.
And if you happen to be trollin' and they hatin', just keep ridin dirty. Never let them catch you - trollers 4 lyfe, you bada$$!
I can't tell if this is a serious question.
it was a serious question, not trolling. thanks for the help
1) Type 1.15 in another cell -- let's call it cell "A1" 2) Ctrl. C cell A1 3) Highlight all cells you want increased by 15% 4) Paste special --> Multiply (Alt. E S M)
Unrelated note: this also works if you want Text --> Values (i.e. lookups aren't working), but instead of "1.15" you use "1".
Sed autem voluptas labore autem consequatur earum nam est. Beatae ea quas atque nemo voluptatem magni minus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...