Formula problem
 

Dear Sir,
I m using this function =IF(AND($A$1="gopal minerals",'Gopal
Sales'!E60),'Gopal Sales'!E6,AND($A$1="Micro Products",'Micro
Sales'!E60,'Micro Sales'!E6,$A$1="Ultra Fine Filler Private Limited", 'Ultra
Sales'!E60, '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

Formula problem
 

=IF(AND($A$1="gopal minerals",'Gopal Sales'!E60),'Gopal Sales'!E6,
IF(AND($A$1="Micro Products",'Micro Sales'!E60),'Micro Sales'!E6,
IF(AND($A$1="Ultra Fine Filler Private Limited",'Ultra Sales'!E60),'Ultra
Sales'!E6,"")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rao Ratan Singh" wrote in message
...
Dear Sir,
I m using this function =IF(AND($A$1="gopal minerals",'Gopal
Sales'!E60),'Gopal Sales'!E6,AND($A$1="Micro Products",'Micro
Sales'!E60,'Micro Sales'!E6,$A$1="Ultra Fine Filler Private Limited",
'Ultra
Sales'!E60, '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 Bob
 

Thank you sir,
It is working. thanks and regards

yours

RRS

Thank you Bob
 

My pleasure sir!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rao Ratan Singh" wrote in message
...
Thank you sir,
It is working. thanks and regards

yours

RRS