FALSE

[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

 

[Andy B]

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"),"","")))

 

[Fernando Duran]

Thanks, simple, but I didn't know that I can add one more statement

Fernando