Post #152,953
4/28/04 6:07:46 PM
|
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/]
|
Post #152,954
4/28/04 6:13:06 PM
|
Just wrap it in another if statement
IF(D14="","",IF(SUM(G14-(H14+I14+J14))=0,"$0.00",SUM(G14-(H14+I14+J14))))
|
Post #152,955
4/28/04 6:13:22 PM
|
Here's one.
Set the formula for K14 to:
=If(isblank(d14),"",<whatever you need it to be>)
bcnu, Mikem
|
Post #153,077
4/29/04 10:28:34 AM
|
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
|
Post #153,080
4/29/04 10:34:00 AM
|
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
|
Post #153,081
4/29/04 10:41:17 AM
|
We'll make a programmer out of you yet.
And welcome to zIWETHEY. :-)
|
Post #153,530
5/3/04 3:05:30 PM
|
Re: We'll make a programmer out of you yet.
Thank You
|
Post #153,088
4/29/04 11:59:50 AM
|
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
4/29/04 2:53:28 PM
|
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
4/29/04 5:49:32 PM
|
We have a winner.
bcnu, Mikem
|