I have placed this coding in the formula bar:
=IF(C2="Card",B18,"")
which works fine. The problem is that I need to evaluate more than 1 value such as:
=IF(C2="Card" & D17=5,B18,"")
But this does NOT work. If I remove C2 or D17 it works but together it does not. Can someone please suggest something?
Thank you in advance!
=IF(C2="Card",B18,"")
which works fine. The problem is that I need to evaluate more than 1 value such as:
=IF(C2="Card" & D17=5,B18,"")
But this does NOT work. If I remove C2 or D17 it works but together it does not. Can someone please suggest something?
Thank you in advance!