Conditional Display
 

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

Conditional Display
 

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

Conditional Display
 

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