IWETHEY v. 0.3.0
|
TODO
1,095 registered users | 1
active user
| 0 LpH |
Statistics
Login
|
Create New User
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
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
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
i
we
they
.org
You were a prophet from above, then you came and sucked my blood.
67 ms