AND

=IF(OR(E290,I290,M290,Q290,U290),SUM(E29,I29, M29,Q29,U29,Y29),"")
"Toppers" wrote:

Can you please post example(s) of your formula(e).

"M.Ummer Malik" wrote:

when i apply a ifor formula and if there is a formula in source cell the
result is displaying 0 zero i whish to keep is blank in result cell if result
is 0' if all source cells are empty the result is comming as blank.(if or
formula false)