if condition based on values

[uday]

Hi,

I am trying to extract values from debit and credit column depends on their presence.

If debit column has value then it should reflect in amount column and it is also applicable for credit column. Amount can not be available in both column together.

Regards,
Uday

 

[Marc L]

Hi !

Easy child level logic : A + B = C …​

 

[bosco_yip]

Try,

In C2, copied down :

=IF(COUNT(A2,B2),IF(A2<>"",A2,B2),"")

Regards
Bosco