Formula problem

Dear Sir,
I m using this function =IF(AND($A$1="gopal minerals",'Gopal
Sales'!E6>0),'Gopal Sales'!E6,AND($A$1="Micro Products",'Micro
Sales'!E6>0,'Micro Sales'!E6,$A$1="Ultra Fine Filler Private Limited", 'Ultra
Sales'!E6>0, 'Ultra Sales'!E6,""))

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="gopal minerals",'Gopal Sales'!E6>0),'Gopal Sales'!E6,
IF(AND($A$1="Micro Products",'Micro Sales'!E6>0),'Micro Sales'!E6,
IF(AND($A$1="Ultra Fine Filler Private Limited",'Ultra Sales'!E6>0),'Ultra
Sales'!E6,"")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rao Ratan Singh" <RaoRatanSingh@discussions.microsoft.com> wrote in message
news:9CDAA442-80A4-48D0-9307-9F0B88DD0FC6@microsoft.com...
> Dear Sir,
> I m using this function =IF(AND($A$1="gopal minerals",'Gopal
> Sales'!E6>0),'Gopal Sales'!E6,AND($A$1="Micro Products",'Micro
> Sales'!E6>0,'Micro Sales'!E6,$A$1="Ultra Fine Filler Private Limited",
'Ultra
> Sales'!E6>0, 'Ultra Sales'!E6,""))
>
> 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

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)

"Rao Ratan Singh" <RaoRatanSingh@discussions.microsoft.com> wrote in message
news:634C6A28-3B58-46F6-A20B-FA1F67B5C110@microsoft.com...
> Thank you sir,
> It is working. thanks and regards
>
> yours
>
> RRS