IMY FORMULA IS
=IF(OR(G510,I510),($J$45+SUM($G$47:G51))-SUM($I$47:I51),"")

"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)