Include error checking

  • Thread starter Thread starter Pat
  • Start date Start date
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
 
Pat,

Try this:

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

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

HTH
Frank
 
Back
Top