Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|