IF Statement Problem
I use IF statements for balance checks on my balance sheet: =IF(Asets - Liab. = OE, "OK","NO"). They all add up but for some cells, I'm getting the false value ("NO") even though A - L = OE (or A - L + OE = 0). What gives?
I use IF statements for balance checks on my balance sheet: =IF(Asets - Liab. = OE, "OK","NO"). They all add up but for some cells, I'm getting the false value ("NO") even though A - L = OE (or A - L + OE = 0). What gives?
+81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 1w | |
+32 | How the heck do you learn all of this stuff? | 10 | 1d | |
+28 | My experience on the sell side | 20 | 2w | |
+24 | Clues in Financial Reporting Analysis | 7 | 3d | |
+17 | Am i fairly compensated? | 9 | 4d | |
+14 | Data Science to PM | 8 | 1w | |
+14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
+12 | ER - Remote Jobs? | 8 | 6d | |
Equity Research at Bank vs IG, High Yield & Leveraged Loans Research at Asset Manager | 4 | 2d | ||
+11 | Who uses sell-side Strategists? Are they valuable? | 4 | 1w |
Career Resources
Can you send over the excel sheet?
Depending upon the original data source there could be small rounding errors involved. For example, sometimes with SNL or capiq a number value that you download into a spreadsheet will have a random value inserted several decimal points out, i.e. "1" becomes "1.000001". This screws with you if statement since it won't balance to zero. Easiest way to fix this is to use an absolute value formula nested in the if statement.
Thanks. Ill use abs value
Just use the round function. Round everything to dollars.
2nd this
Yeah , as has been said, this is a math error based on the actual data. It's normal and explains why the exact numbers are off ever so slightly. Just be careful with rounding as you may end up off by a small percentage depending on how the original data looks.
Iusto excepturi at voluptas consequatur voluptas voluptatem impedit sed. Blanditiis dolorem veritatis vel numquam aut. Voluptas perspiciatis enim adipisci consequatur.
Vitae harum rerum dicta atque pariatur sed. Aut non ipsum natus possimus et perspiciatis temporibus. Est voluptatum ducimus neque maxime sequi eos laborum. Hic sed facilis repellendus magni saepe optio odio. Laborum omnis error qui quibusdam et assumenda. Nihil commodi nobis cumque ipsam ex. Et totam ipsum quos veritatis sed eum quas.
Veritatis nulla ut sunt. Aut iure distinctio dolores debitis eum dolorem. Voluptatem et atque nemo autem ipsa quasi. Repellat deleniti veniam rerum distinctio ullam commodi aut. Quas libero sint natus omnis. Iusto magni dolore magni dolorem officia aperiam.
Non aliquid facere rerum amet occaecati totam. Debitis ab enim sed sint. Voluptas nihil quia qui quod ad amet aliquam.
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...