Posted: 2/17/2011 5:22:09 AM EDT
|
Quick question (although I may have to ask a few more):
The formula I am trying to craft is this: If H4 + H5 are Zero, then Zero, if not, then F8 No matter how I lay it out, the formula isn't working. Thanks! |
|
Quoted:
Quick question (although I may have to ask a few more): The formula I am trying to craft is this: If H4 + H5 are Zero, then Zero, if not, then F8 No matter how I lay it out, the formula isn't working. Thanks! Try this 
=if(sum(h4,h5 =0),"0",f8) eta. beat. 
|
|
OK, now I've got it. I was missing the parentheses over the entire formula. Works fine now.
Thanks, fellas. Like I said, I may have another question because I'm in the middle of creating an estimator and have been away from Excell for about 10 years now. My Excell thinking cap is a wee bit rusty. 
|