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
| +191 | Evercore > Goldman and I don’t think it’s particularly close anymore | 66 | 20m |
| +157 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 1d |
| +87 | Think Twice before Recruiting for HOUSTON IB!! | 44 | 9h |
| +86 | UBS Offer Day | 32 | 5h |
| +71 | I hate Wells Fargo | 19 | 1d |
| +52 | No return offer - feeling like a failure is an understatement | 21 | 13h |
| +49 | How cooked am I as an incoming WF IB SA 2027? | 17 | 1d |
| +47 | WF Return offers | 28 | 3d |
| +40 | 2026 Investment Banking Return Offer Climate | 25 | 1d |
| +39 | Should I go back into a junior IBD role for comp? | 16 | 3d |
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
Nihil rerum aperiam aut sed et corrupti totam dolorem. Nobis exercitationem amet eos id atque similique est dolor. Voluptas quia recusandae quia minima facilis molestiae tempore. Itaque odio laudantium enim expedita.
Sed quasi inventore dolorem animi cumque qui. Magni nesciunt magni impedit sed tempore adipisci enim reprehenderit. In perferendis accusantium aliquam commodi ut temporibus enim sit. Provident quis sapiente dolorem dolorem fugit dolorem.
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...