#value!
 

Hi,
Novice Excel user here...

H5=

=IF(AND(ISBLANK(C5),ISBLANK(D5),ISBLANK(E5),ISBLAN K(F5)),"$0.00",SUM(C5,D5,E5,F5))


I5=


=IF(AND(ISBLANK(G5),ISBLANK(H5)),"",I4-G5+H5)

This formula works, however the subsequent rows (H6 to H41) and (I6 to
I41)are filled with $0.00.

If I change H5 to:

=IF(AND(ISBLANK(C5),ISBLANK(D5),ISBLANK(E5),ISBLAN K(F5)),"",SUM(C5,D5,E5,F5))

I receive a #VALUE! in column I5 to I41, and the values entered in G5
to G41 aren't added to I6 to I41. If I add values to CDEF5 to 41, then
it records the value in G.

Bottom line, How can I get rid of the extra $0.00 in (H5 to H41) and
(I5 to I41) and replace them with a blank cell?

The file should be attached, any help would be greatly appreciated.


+-------------------------------------------------------------------+
|Filename: FINANCES.ZIP |
|Download: http://forums.yourdomain.com.au/attachment.php?attachmentid=620|
+-------------------------------------------------------------------+

--
Nepe

Nepe Wrote:
Hi,
Novice Excel user here...

H5=

=IF(AND(ISBLANK(C5),ISBLANK(D5),ISBLANK(E5),ISBLAN K(F5)),"$0.00",SUM(C5,D5,E5,F5))


I5=


=IF(AND(ISBLANK(G5),ISBLANK(H5)),"",I4-G5+H5)

This formula works, however the subsequent rows (H6 to H41) and (I6 to
I41)are filled with $0.00.

If I change H5 to:

=IF(AND(ISBLANK(C5),ISBLANK(D5),ISBLANK(E5),ISBLAN K(F5)),"",SUM(C5,D5,E5,F5))

I receive a #VALUE! in column I5 to I41, and the values entered in G5
to G41 aren't added to I6 to I41. If I add values to CDEF5 to 41, then
it records the value in G.

Bottom line, How can I get rid of the extra $0.00 in (H5 to H41) and
(I5 to I41) and replace them with a blank cell?

The file should be attached, any help would be greatly appreciated.

Try these formulae:
In H5 =IF(SUM(C5:F5),SUM(C5:F5)," ")
In I5 =IF(SUM(C5:F5),I4-G5+H5," ")


--
jahoobob