FALSE

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

Fernando Duran

I have this formula, that when the other cell is empty, return a FALSE
statement, and I want to know if it's possible to eliminate this.

=IF(E4="POST",'Post Rates'!I12, IF(E4="CANPAR",'Canpar
Rates'!L16,IF(OR(E4="CARRERA",E4="CANPAR-MTL",E4="PICK-UP"),"")))

Thanks

Fernando
 
Hi

Just add another ,"" at the end:

=IF(E4="POST",'Post Rates'!I12, IF(E4="CANPAR",'Canpar
Rates'!L16,IF(OR(E4="CARRERA",E4="CANPAR-MTL",E4="PICK-UP"),"","")))
 
Back
Top