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

Welcome to IWETHEY!

New Excel question
My Dad has an Excel spreadsheet. I don't know the first thing about programming stuff like this in Excel, but he knows that I know people who do. So here's the question:

The Cell in question is K14.
If Cell D14 is blank, then Cell K14 must be blank as well.
If Cell D14 is not blank, then Cell K14 should be: =IF(SUM(G14-(H14+I14+J14))=0,"$0.00",SUM(G14-(H14+I14+J14)))

Any help is appreciated.
-YendorMike

[link|http://www.hope-ride.org/|http://www.hope-ride.org/]
New Just wrap it in another if statement
IF(D14="","",IF(SUM(G14-(H14+I14+J14))=0,"$0.00",SUM(G14-(H14+I14+J14))))
New Here's one.
Set the formula for K14 to:

=If(isblank(d14),"",<whatever you need it to be>)
bcnu,
Mikem
New Re: Here's one.
Mike,

Thanks for the help, however as I am not a Excel programmer I may have misunderstood what you meant. Based upon your solution my complete statement now looks like this:

=If(isblank(d16),"",SUM(G16-(H16+I16+J16))=0,"$0.00",SUM(G16-(H16+I16+J16)))

Excel claims there is an error in this formula but it does not suggest how to correct it.

Would you provide a little help?

Thanks

Al
New 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
New We'll make a programmer out of you yet.
And welcome to zIWETHEY. :-)
New Re: We'll make a programmer out of you yet.
Thank You
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)

It's all fun and games until someone loses a lung.
151 ms