Formula problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
My pleasure sir!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top