Include error checking

P

Pat

=IF(BL484="saleable",(SUBSTITUTE(TRIM(BS484&" "&BT484)," ",",")))

I want to include error checking so that if BL484 does not contain a value
it will not return FALSE

Thanks in advance!

Pat
 
J

John Wilson

Pat,

Try this:

=IF(BL484="saleable",(SUBSTITUTE(TRIM(BS484&" "&BT484)," ",",")),"")

John
 
F

Frank Kabel

Hi Pat
try
=IF(BL484="saleable",(SUBSTITUTE(TRIM(BS484&" "&BT484)," ",",")),"")

HTH
Frank
 
Top