Hey everyone, working on my lbo model and all of the sudden I have #DIV/O! errors all over. Does anyone know why this happens or an easy way to figure out where the error is coming from or how to fix it? I really don't want to have to start over from the previous version.
Excel 2007 in case that makes a difference.
Thanks in advance.
probably referenced a blank cell by accident and Excel went nuts
no bank uses excel 2007
"Prospective Monkey" boutiquebank, would my "PE" icon indicate that I work at a bank? Go back to your dorm room and start talking shit when you have a job.
LMAOOOOOOOOOOOOOO u old fuck upgrade your windows 98 u slimey roasted corn dog -- btw +1sb made me laugh so hard
Yeah, you need your cells to have values instead of blanks when doing division.
this occurs when you are attempting to divide by zero or a blank cell. choose a #DIV/O! cell and trace precedents. if that takes you to a cell with a #DIV/O! error, then do it again until you find a 0 or blank.
If its all over your model, its going to be a bastard to figure out which cell is the problem. I hope you've been saving up so you can go to the last version of the model and start from there.
"no bank uses excel 2007"
Rephrase to "no noname bank uses excel 2007, such as my boutique"
Less: "no bank uses excel 2007" Plus: "my boutique bank can't afford excel 2007" Plus: "and CFO clients always shame us when they send us excel 2007 models"
1) Fix your ref / mistake that caused the #DIV/0 - if you changed a reference by accident, press undo or something. This will not fix your model but is necessary for following steps 2) Ctrl-H, find: = replace with: WSO4Life 3) Replace 4) Calculate 5) Ctrl-H, find: WSO4Life, replace with: = 6) Replace 7) Profit.
This trick has saved me countless times.
If you have an absolute reference, make sure it is an absolute reference ex. $B$4
Whenever this happens to me, it's generally just Excel being buggy cause of some circular references. I'd hardcode in some zeroes for interest expense, your revolver, and cash line items, calculate, then put the formulas back in, recalc again. If it's still DIVing all over, then I'd keep trying this trick throughout the usual trouble spots of the model.
Excel '07 is way better. I can't wait until we switch to '10 - sparklines are money sons.
...you work in PE and can't troubleshoot a model?
Mighta been a consultant before....but that's a bit stretching for benefit of the doubt.
Bottom line is that you have a circularity(most likely) and need to check out one of the lines involved in that circularity.
In the future make sure that when you have a circularity you build them with an "if" statement that allows you to manually set their values to some arbitrary number, then revert them. This breaks the circularity and stops errors from feeding forward so that it will calculate correctly when you put the formula back in.
The way most modeling programs teach you do this is a pain in the ass, they'll want you to copy-paste values in and out. You can do this in a pinch(like if you forgot to put a circuit breaker in) but in general adding your circuit breaker should be one of the first things you do in a model, and you should throw your if statement in as soon as you build your first circularity.
Et dolorum et aspernatur officia deserunt tenetur porro eius. Quasi voluptatum ut est quis eaque est nihil. Laudantium quam porro mollitia nobis incidunt ad. Perspiciatis et et dicta quibusdam. Quia aliquam est et est occaecati deserunt. Eum aut quasi quod voluptas enim omnis et.
Nemo omnis eum sit deleniti eligendi blanditiis unde. Temporibus sit placeat omnis et quod dicta est.
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...