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

Marcelo Wrote:
if(or(a2=0,a2="",0,...)

.... = your formula

hth
regards from Brazil
Marcelo

"M.Ummer Malik" escreveu:

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)


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555981