Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave O
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Logical ELSE statements Ruth Excel Discussion (Misc queries) 2 June 23rd 05 03:23 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Nested IF statements John Simons Excel Worksheet Functions 14 February 16th 05 06:17 AM
An easy macro question and one I believe to be a little more diffi TroutKing Excel Worksheet Functions 3 January 18th 05 09:17 PM
If statements Mark Excel Worksheet Functions 3 November 2nd 04 08:39 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"