Triple IF?
 

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.

Triple IF?
 

On Sunday, April 1, 2012 11:05:27 AM UTC-5, Bampah wrote:
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))

Triple IF?
 

On Apr 1, 6:15*pm, Don Guillett wrote:
On Sunday, April 1, 2012 11:05:27 AM UTC-5, Bampah wrote:
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))

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