Change #VALUE! from source to null in target


I need help with a formula. Some of the data in my source is invalid and has #VALUE! in the Value column. This is causing the insert\update to fail for the row.

I created this formula IF(ISERROR(S3), " " , S3 ). To me this says, if the source is an error, enter null. If not, enter the value in S3.

However, #VALUE! is still being sent to the target. What should the formula be?

Any help is appreciated.

Posted by Stephanie S. on Nov 16 2009 1:52PM { U724 , F9 , T979 , C2810 }

(6) Answers