Formula problem

[Rao Ratan Singh]

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

 

[Bob Phillips]

=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]

Thank you sir,
It is working. thanks and regards

yours

RRS

 

[Bob Phillips]

My pleasure sir!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)