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

Hi!

Tyr this:

=IF(ISTEXT(B1),IF(D13,0,6),"")

Biff

"Bampah" wrote in message
oups.com...
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

Thanks Biff

I actually sorted it out myself straight after I posted my plea for
help.

I used this formula

IF(D13,0,IF(B1<"",6,0))

I ahve tried your answer and it works fine also with one strange
result.
When I pasted it into cell C1 it merged cells C1 & C2....bizarre.

Thanks again