I have made a sheet for show ticket sales
Col A =3D Ticket No.
Col B =3D Name
Col C =3D Ticket Cost (=A36)
Col D =3D Paid.

Also Col C shows =A36 in every row due to the function =3DIF(D1>3,0,6)
I would only like the =A36 to be shown in C1 if there is text in B1. OTW
it is
to remain blank.
I've tried everything to achieve this but can't.
Over to you please