Triple IF?

[Bampah]

I have a sheet for tracking ticket sales.
Members pay £30 & guests pay £35.
In column A, I have the persons name and in column B an x designates
if a person is a member.
In column C I would like to show the amount they are due to pay but
only if there is an entry in Col A.
If there is no text in Col A, Col C should show zero
If there is an x in Col B, Col C should show £30
If there is no x in Col B, Col C should show £35.
I am sure I have coped with this easily in the past but cannot for the
life of me remember how.

 

[Don Guillett]

I have a sheet for tracking ticket sales.
Members pay £30 & guests pay £35.
In column A, I have the persons name and in column B an x designates
if a person is a member.
In column C I would like to show the amount they are due to pay but
only if there is an entry in Col A.
If there is no text in Col A, Col C should show zero
If there is an x in Col B, Col C should show £30
If there is no x in Col B, Col C should show £35.
I am sure I have coped with this easily in the past but cannot for the
life of me remember how.

=IF(A2="","",IF(B2="x",30,35))

 

[Bampah]

=IF(A2="","",IF(B2="x",30,35))

Thanks Don. Worked perfectly. My problem was that I was looking for a
positive in A2 and didn't think of using the negative.