Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
First, a question / comment: the formula you're using now says "if the
account balance in E2 is not zero, subtract E2 from D2". Since it's possible- maybe not probable, but possible- for an account to legitimately hold a zero balance, could this be the source of a logic error? If this is totally not possible then try this formula, which is based on your example formula: =IF(AND(D2<0,E2<""),D2-E2,"") If it may be possible for accounts to legitimately hold a zero balance and you need to consider this possibility, try this formula: =IF(AND(D2<"",E2<""),D2-E2,"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Logical ELSE statements | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Nested IF statements | Excel Worksheet Functions | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions |