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?
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?