Want to verify cells are equal, but getting reversed 'true' 'false' values in IF() statement...
I have a large SmartSheet that contains deposit information for my company plus others we do billing for. Since payments come in long after the service date in healthcare, I may get an outlier payment for a company that is no longer active in current year, but need to process.
I've created a cell 'All Deposits' that is the sum of [Credit Amount]:[Credit Amount]. I've created Sub-Totals for each known company by using SumIf statements for each company. I've then created a Formula Check to ensure the sum of the Sub-Totals is equal to the sum of All Deposits to make sure I am not overlooking an outlier company payment from years past.
Despite values of both 'All Deposits' and sum of 'Sub-Totals' looking identical on screen at $4,837,354.40, when I write an IF() statement to verify the two cells are equal and return OK or Calc Error response, I get 'Calc Error' even though the data appears true. I have checked formatting for cells, decimal places beyond hundredths, moved to different columns to avoid circular references but nothing works. I've even tried using <> and reversing my desired output, but still get the false response. Any thoughts?
Here are my formulas:
Deposit1=SUM([Credit Amount]:[Credit Amount]) //value = $4,837,354.40//
Deposit2:Deposit7=SUMIF(Company:Company, [Sub Headers]@row, [Credit Amount]:[Credit Amount])
Alert Message=IF(Deposit1 = Deposit8, "OK", "ERROR!") //value="ERROR!"//
Help Article Resources
Check out the Formula Handbook template!