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 / One more reduction
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

That money came from someplace.
44 ms