I think we all have these WTF moments, or WTF was I thinking moments. However, today, my boss and I was going over a spreadsheet because there were some issues in the outcome of the numbers. We knew it couldn't be right. So... We started the trace dependence and trace precedence on a few cells to begin our journey (something I taught him how to do a few days ago cause I'm excel smart-NOT). Now, neither one of us created this spreadsheet originally, but both of us have added tweaks here and there in an attempt to gather more information. We get to one cell where the formula would have been to take the daily cost of an expense, figured into cost for the year, divided by amount of employees then divided by workdays per year. Sounds easy right?
He clicks on the cell, see's the formula and says, "Wtf is this?" (Sorry, I'm laughing hard right now typing this because, well, just wait). He starts reading the formula (which he really didn't need too, I could see it on the big screen on the wall) and as I follow along, I just started laughing hard. I told him, you know, I would love to blame this on Russ (guy who originally built the spreadsheet) but, that's my shit right there. He says, What does it mean? (Now I'm laughing hard enough my eyes are watering while preparing to explain). Before I post the formula, I did it 3 yrs ago and had not messed with excel for quit sometime. My knowledge of excel was very beginner level (and still is, but better). So here's the formula:
=SUM(I30*5*4*12/(E26+F27)/222
What did I do wrong and why was the outcome wrong? I mean, I know the answer, NOW!
He clicks on the cell, see's the formula and says, "Wtf is this?" (Sorry, I'm laughing hard right now typing this because, well, just wait). He starts reading the formula (which he really didn't need too, I could see it on the big screen on the wall) and as I follow along, I just started laughing hard. I told him, you know, I would love to blame this on Russ (guy who originally built the spreadsheet) but, that's my shit right there. He says, What does it mean? (Now I'm laughing hard enough my eyes are watering while preparing to explain). Before I post the formula, I did it 3 yrs ago and had not messed with excel for quit sometime. My knowledge of excel was very beginner level (and still is, but better). So here's the formula:
=SUM(I30*5*4*12/(E26+F27)/222
What did I do wrong and why was the outcome wrong? I mean, I know the answer, NOW!
![[Image: 4CV0TeR.png]](https://i.imgur.com/4CV0TeR.png)
