I'm trying to join two cells that have the top and bottom EBITDA multiples into one cell that will show the range:
So for example, if cell A1 is showing 7.0x and cell A2 is showing 8.0x, I want cell A3 to show 7.0x - 8.0x.
I've tried using =A1&"x - "&A2&"x", but I can't get the .0 zeros to show after the numbers 7 and 8.
Can someone help please?
Thanks
| +186 | Americas M&A League Table Q2 Updated | 75 | 5h |
| +135 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 29 | 38m |
| +115 | Restructuring: Anti-climactic Experience | 30 | 5h |
| +85 | IB Net Worth / Savings Check | 35 | 2h |
| +75 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 2d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 1d |
| +37 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 12 | 1h |
| +31 | PWP vs BofA | 23 | 13h |
| +27 | Who pays the highest right now? | 14 | 13h |
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.
Just put a .0 in front of the x in the quotation marks. Formula will read like this: =A1&".0x - "&B1&".0x"
How would you write an exception handler for let's say mult of 7.1 and 8.1?
.
In the case of 7.1 to 8.1, the original formula would work because the cell the formula is looking into is showing a 7.1. With 7.0x, the number in the cell is 7, which is why the output is 7x rather than 7.0x.
Right, but was asking how it would handle dynamically, i.e. a formula that could show that output with either #.0x or #.1x as input as so one wouldn't have to change for each case. Monkeyed around with an +IF(ISERROR(...)) but no such luck.
You can use the MOD function (returns the remainder after a number is divided by a specific divisor), like this:
=IF(MOD(A1,1)=0,A1&".0x - "&A2&".0x",A1&"x - "&A2&"x")
This obviously only checks the first multiple in A1, and you have to nest some more if statements to do the whole thing, but this should work. Sorry I was too lazy to make the full statement haha
=CONCATENATE(TEXT(A1,"0.0x"),"-",TEXT(B1,"0.0x"))
Done.
Oh that haha, well done & thanks
Yea, so mine's not nearly as elegant as Flakes. Don't use mine ha.
3
Aut qui labore qui dolores error ut dicta qui. Ipsam aperiam provident vitae voluptates. Dignissimos explicabo autem est veritatis nihil et. Exercitationem ipsam cumque dolor sunt deserunt voluptas ratione corrupti.
Molestiae minus consequuntur velit sed. Unde ab facilis neque autem. Aliquid ducimus est quam vel numquam praesentium qui. Voluptatem autem vel odio. Velit eaque fugit tempore aut esse dolorem.
Autem perferendis quo asperiores quaerat earum eveniet error. Aut tempore vel quod. Quis odit reprehenderit rerum saepe. Molestiae tenetur vel consectetur dolor laborum et. Autem omnis est at minus aut aut magnam.
Quasi quia ut cumque voluptatem dignissimos. Commodi illum velit dolores. Ducimus dolor sit possimus aut dolor voluptatem sequi rem. Sit quia consequatur beatae rerum nihil natus.
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...