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

Also Col C shows £6 in every row due to the function =IF(D13,0,6)
I would only like the £6 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