software

Dear Sir,
I m using this function =IF(AND($A$1=quot;gopal mineralsquot;,'Gopal
Sales'!E6gt;0),'Gopal Sales'!E6,AND($A$1=quot;Micro Productsquot;,'Micro
Sales'!E6gt;0,'Micro Sales'!E6,$A$1=quot;Ultra Fine Filler Private Limitedquot;, 'Ultra
Sales'!E6gt;0, 'Ultra Sales'!E6,quot;quot;))

but when it found empty cells in respective sheet it returns #value!. I want
it should return blank.

How it can be. solve my problem please.

RRS

=IF(AND($A$1=quot;gopal mineralsquot;,'Gopal Sales'!E6gt;0),'Gopal Sales'!E6,
IF(AND($A$1=quot;Micro Productsquot;,'Micro Sales'!E6gt;0),'Micro Sales'!E6,
IF(AND($A$1=quot;Ultra Fine Filler Private Limitedquot;,'Ultra Sales'!E6gt;0),'Ultra
Sales'!E6,quot;quot;)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Rao Ratan Singhquot; gt; wrote in message
...
gt; Dear Sir,
gt; I m using this function =IF(AND($A$1=quot;gopal mineralsquot;,'Gopal
gt; Sales'!E6gt;0),'Gopal Sales'!E6,AND($A$1=quot;Micro Productsquot;,'Micro
gt; Sales'!E6gt;0,'Micro Sales'!E6,$A$1=quot;Ultra Fine Filler Private Limitedquot;,
'Ultra
gt; Sales'!E6gt;0, 'Ultra Sales'!E6,quot;quot;))
gt;
gt; but when it found empty cells in respective sheet it returns #value!. I
want
gt; it should return blank.
gt;
gt; How it can be. solve my problem please.
gt;
gt; RRS
Thank you sir,
It is working. thanks and regards

yours

RRS

My pleasure sir!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Rao Ratan Singhquot; gt; wrote in message
...
gt; Thank you sir,
gt; It is working. thanks and regards
gt;
gt; yours
gt;
gt; RRS