I have a column formatted as Currency and I calculate its value from other cells. However if both of the other cells are blank, I want the Currency cell to be blank also. I've tried may ways without success, the last one being =IF(AND(ISBLANK(D4),ISBLANK(E4)),,F$2+SUM(D$2:D4)-SUM(E$2:E4)) this prints $0.00 into the cell. How can I leave the cell blank if both D4 and E4 are blank?

TIA, Pete