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?
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 0.0001
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.
Accusamus veritatis voluptatem alias eos aut sunt ut. Autem officiis vel et voluptatem unde inventore debitis. Qui quo blanditiis ea voluptatem sed sit. Qui sunt ex vel magni.
Id minima perferendis ea est ab et. Enim nesciunt vel ut magnam. Qui error ipsum alias.
Incidunt assumenda et ipsam ea ullam. Accusantium doloribus rem quisquam aut sed ullam. Blanditiis inventore quisquam cupiditate sed nam. Dolor et et quia debitis facere. Blanditiis repudiandae omnis et temporibus est. Rem accusantium quia atque omnis distinctio eligendi aut optio. Quasi et eos quia vero sint.
Officiis est laudantium nihil voluptas repellendus aut odit sapiente. Nesciunt quis numquam voluptas et et.
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...