What is wrong with this formula?

[kafka]

I am trying to create an IF/OR Function which will give a grand total if one or more of the cells contains a number and will leave the calculated cell blank if there are no numbers in any of the cells. The formula looks right to me but, instead of leaving the calculated cell blank if there are no numbers in the specified cells, it puts a 0 (zero). What am I doing wrong?

IF(OR(S8>0,T8>0),SUM(TOTAL!L4306:L4346)+SUM('2NDTOTAL'!L1829:L1869)+$AW54,"")

 

[AlphaFrog]

If S8 or T8 has a space character in them, they may "look" empty, but they are not.

This would ignore text and spaces in S8 and T8
IF(OR(N(S8)>0,N(T8)>0),...

 

[igold]

You might want to change the false part of the if statement to something like "False" instead of "". That way you can be sure you are getting the false result back. I know it sounds stupid but I have seen the same thing a bunch of times where everyone just thought the formula was returning the false part, but it was really returning the true part.

Just a thought.

 

[kafka]

Thanks both of you. I tried AlphaFrog's suggestion and it worked perfectly. There is no way I could have discovered that method by myself.

If S8 or T8 has a space character in them, they may "look" empty, but they are not.

This would ignore text and spaces in S8 and T8
IF(OR(N(S8)>0,N(T8)>0),...

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...t-is-wrong-with-this-formula.html#post5131300
@kafka
For future reference, while we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.