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!

IWETHEY Home / IWETHEY Board / Whither Scripting? Forum / Heck you don;t even need:
Post #153,088
by folkert
Picture of folkert
4/29/04 11:59:50 AM
Reply
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!
Post #153,112
by jbrabeck
4/29/04 2:53:28 PM
Reply
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.
Post #153,140
by mmoffitt
4/29/04 5:49:32 PM
Reply
New We have a winner.
bcnu,
Mikem
     Excel question - (Yendor) - (9) - April 28, 2004, 06:07:46 PM EDT
         Just wrap it in another if statement - (ChrisR) - April 28, 2004, 06:13:06 PM EDT
         Here's one. - (mmoffitt) - (7) - April 28, 2004, 06:13:22 PM EDT
             Re: Here's one. - (alvitale) - April 29, 2004, 10:28:34 AM EDT
             Re: Here's one. - (alvitale) - (5) - April 29, 2004, 10:34:00 AM EDT
                 We'll make a programmer out of you yet. - (ChrisR) - (1) - April 29, 2004, 10:41:17 AM EDT
                     Re: We'll make a programmer out of you yet. - (alvitale) - May 3, 2004, 03:05:30 PM EDT
                 Heck you don;t even need: - (folkert) - (2) - April 29, 2004, 11:59:50 AM EDT
                     One more reduction - (jbrabeck) - (1) - April 29, 2004, 02:53:28 PM EDT
                         We have a winner. -NT - (mmoffitt) - April 29, 2004, 05:49:32 PM EDT

Consider the job: to build a structure based on live bone and meat that has to perform under extreme forces in one of the most corrosive environments on the planet. Has to look good too.
33 ms