IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New 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!] @ iwethey

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!
New 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.
New We have a winner.
bcnu,
Mikem
     Excel question - (Yendor) - (9)
         Just wrap it in another if statement - (ChrisR)
         Here's one. - (mmoffitt) - (7)
             Re: Here's one. - (alvitale)
             Re: Here's one. - (alvitale) - (5)
                 We'll make a programmer out of you yet. - (ChrisR) - (1)
                     Re: We'll make a programmer out of you yet. - (alvitale)
                 Heck you don;t even need: - (folkert) - (2)
                     One more reduction - (jbrabeck) - (1)
                         We have a winner. -NT - (mmoffitt)

Your Freak God[tm] is HERE!
177 ms