Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Triple Number | Excel Programming | |||
Triple Filter | Excel Programming | |||
Triple lookup? | Excel Worksheet Functions | |||
Triple Criteria Formula | Excel Programming | |||
Triple Lookup Formula! | Excel Programming |