Re: Here's one.

Post #153,080 by alvitale 4/29/04 10:34:00 AM Reply	Re: Here's one. Mike, Please ignore my earlier response. I played with it until I got it working. The final version is: =IF(ISBLANK(D16),"",IF(SUM(G16-(H16+I16+J16))=0,"$0.00",SUM(G16-(H16+I16+J16)))) Thanks again. Al Vitale
Post #153,081 by ChrisR 4/29/04 10:41:17 AM Reply	We'll make a programmer out of you yet. And welcome to zIWETHEY. :-)
Post #153,530 by alvitale 5/3/04 3:05:30 PM Reply	Re: We'll make a programmer out of you yet. Thank You
Post #153,088 by folkert 4/29/04 11:59:50 AM Reply	Heck you don;t even need: `=IF(ISBLANK(D16),"",IF(SUM(G16-(H16+I16+J16))=0,"$0.00",SUM(G16-(H16+I16+J16)))` Is more than you need. `=IF(ISBLANK(D16),"",IF(G16-(SUM(H16,J16))=0,0,G16-(SUM(H16,J16)))` Just format the cell as $0.00, and it'll do it automagically. Blank entry will be blank. It should put what D16 is actually. Of course I might pulling this from `/dev/ass` -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* Give a man a match, he'll be warm for a minute. Set him on fire, he'll be warm for the rest of his life!
Post #153,112 by jbrabeck 4/29/04 2:53:28 PM Reply	One more reduction Why this =IF(ISBLANK(D16),"",IF(G16-(SUM(H16,J16))=0,0,G16-(SUM(H16,J16))) Why not =IF(ISBLANK(D16),"",G16-(SUM(H16,J16)). Again format cell as $0.00. No need to check for zero.
Post #153,140 by mmoffitt 4/29/04 5:49:32 PM Reply	We have a winner. bcnu, Mikem

Welcome to IWETHEY!