Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Failing IF Statement
I am using a nested If statement for some financial reports. i have a sheet
for each month of the year. With/in each sheet there is the same cells for each week: Date Service Orders Deposit Checking Account Accounts Receivable Out to the right of each of these, I enter the amount for that week for each. Farther to the right, the Accounts Receivable is also calculated based on last weeks total and this weeks entries. It then compares the calculated amount to the actual entered amount from accouting software & tells me if I am balanced or not. The statement has been working all year long until today & can't figure out why it's not working. Here is the If Statement in question: =If(C15="","",IF(C15=E15,"Balanced","ERROR!")) This formula is in box E16. For the week above it, it came out as balanced because the two AR amounts match. This week, the AR amounts match and it says: ERROR! I also have a formula in the cell to the right that calculates the difference if the result is ERROR!, it is saying $0. Can anyone help me out? The formula is exactly the same as all the others because I copied & pasted them all. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a logical test on a date is failing | Excel Worksheet Functions | |||
Data query failing | Excel Worksheet Functions | |||
COUNTA failing? | Excel Discussion (Misc queries) | |||
My formulas are failing! | Excel Discussion (Misc queries) | |||
Link 'failing' | Links and Linking in Excel |