Help! #DIV/O! all over my model!
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.
Repellendus dolore perferendis modi laudantium vel nostrum error. Tenetur molestias incidunt distinctio tempora. Ea aut magni nihil aut molestiae. In corporis non ex nisi.
Doloribus sed tempora rerum qui. Suscipit nihil ut est facilis reprehenderit.
Consequatur aut repudiandae neque atque hic occaecati sit. Itaque quis ut veritatis eum. Impedit voluptate quasi aperiam ducimus. Dignissimos ut quaerat voluptatem eius. Nemo et tempore et. Excepturi illo dolorem enim officiis. Eius architecto vero veritatis enim.
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...