calculation

[M.Ummer Malik]

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)

 

[Toppers]

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

 

[Marcelo]

if(or(a2=0,a2="",0,...)

.... = your formula

hth
regards from Brazil
Marcelo

"M.Ummer Malik" escreveu:

 

[starguy]

hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...)

 

[starguy]

hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...)

 

[starguy]

hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...)

 

[starguy]

hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...)

 

[starguy]

hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...)

 

[starguy]

hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...)

 

[M.Ummer Malik]

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

 

[M.Ummer Malik]

AND

=IF(OR(E29>0,I29>0,M29>0,Q29>0,U29>0),SUM(E29,I29,M29,Q29,U29,Y29),"")

 

[starguy]

AND

=IF(OR(E29>0,I29>0,M29>0,Q29>0,U29>0),SUM(E29,I29,M29,Q29,U29,Y29),"")

no problem in this formula. its correct.