B
Bampah
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(D1>3,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
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(D1>3,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