iferror

[Thuch Vannarath]

Hi everyone, I want to use iferror function. Ex. A1 = 12 ,B1= #value!(link from another cell) So for C1 cell I want to use iferror function as my expect result is that if A1= 12, B1=#value! So C1=A1(=12) and if A1=12, B1=10 so C1=A1-B1.Thanks in advance.

[BillyJoeBob]

=+a1-iferror(b1,0)

[alvin-chung]

Hi Thuch, another variation.

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[Thuch Vannarath]

Thank, that two ways work the same.

[alvin-chung]

You're welcome, and thanks for the repu


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin