Quote:
Originally Posted by Pecoflyer
Please post a sample sheet ( not an image - see FAQ) showing what goes wrong
|
Thanks everyone for trying to help me. the original formula works now . I wasn't entering anything in column B, once I enter a description in column B the amount entered in columns C & D are calculated and a running total in column E is working perfectly.
The formula that worked is =IF(B5="","",E4-C5+D5)
Thanks to all once again