Meaning of these formulas

[sxmajmda]

I understand that all these formulas add (except no. 5), but what I really want to know is what do they mean

1) IF(OR(C11<>0,C12),C11+C12,"")


2) IF(OR(ISNUMBER(C10),ISNUMBER(C13)),SUM(C10)+SUM(C13),"")


3) IF(OR(C15<>0,C16),C15+C16,"")


4) IF(SUM(C11:N11),SUM(C11:N11),"")


5) IF(ISNUMBER(C10),C10,"")

Thanks in advance,
SXM

 

[sxmajmda]

Thank you so very much..you are a life saver.

 

[sxmajmda]

I have this formula =IF(B7=C7, "Pass", "Fail"), it works, but when the cells are blank it says pass, I want the comment to remain blank if both B7 and C7 (in this case) are blank....

Thanks in advance,

 

[Andrew Poulsom]

Try:

=IF(LEN(B7&C7),IF(B7=C7, "Pass", "Fail"),"")

 

[sxmajmda]

Thanks again for the prompt response, can't thank you enough

 

[Scott Huish]

Also:

=IF(B7&C7="","",IF(B7=C7,"Pass","Fail"))