• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to avoid #N/A into a copy cell

tazz

Member
Hello,

In cell A1 I have a formula that gives me a value. When I eliminate 1 variable the result is #N/A.

I need cell B1 to copy the final result from A1 or if there(A1) is #N/A, I want this cell(B1) to be empty.

I tried this: =IF(A1="#N/A","",A1)but is still returning #N/A.

Any ideas?
 
Back
Top