Multiply IF(OR statements?

[JTL9161]

In Columns B3,H3 and N3 I have a name BOB

Now depending on how BOB pays is where I enter the amount
Col B is for Venmo
Col H is for PayPal
Col N is for Check

If BOB pays $100 via Venmo, I enter $100 in cell C3. If he pays via PayPal I put $100 in cell I3 and with a check I put $100 in cell O3

What I want the formula to do is depending on the way they pay for example Venmo,
then I want his name removed from cell H3 and N3
if by PayPal I want BOB removed from cells B3 and N3
and if they pay by check I want the name BOB removed from cells B3 and H3.

I'm thinking like a IF(OR statement but cant seem to get it to work as above. I also have the name in cell U3 so to use that name in the cell based on what how he pays. If he pays $100 via Venmo then take the name in cell U3 and put it in cell B3. Same for PayPal and Check

Hope I explained this clearly enough

Thanks in advance
James

 

[DanteAmor]

How about:

Libro1
	A	B	C	D			G	H	I	J			M	N	O	P				T	U	V
1
2
3								BOB	2												BOB
4
Hoja1

Cell Formulas
Range	Formula
B3,N3,H3	B3	=IF(C3="","",$U3)

 

[JTL9161]

Perfect. thank you