#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
|