Three possible outputs from an if statement.

D

Dogfox

Hi. I currently have an if statement: =(IF(CELL="","OPEN","CLOSED") but I
want to amend this to include a third possibility which is that if C91
contains "P/S" that the output will be "P/S"

At present if the CELL is blank I get the result "OPEN". If the cell is not
blank I get "CLOSED". I would like to have a third output for the statement
if the CELL includes P/S (ie partially sold) then output should be "P/S"

I think this is done by combining conditional statements but I cannot work
it out as the if statement is logical value if true, otherwise false

Can anyone help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"If" statement 1
If statement that outputs specific text if cell is not null 2
If statement - blank cell 2
If statement 8
If statement with dates 0
If blank statement 4
Three condition "if" statements 2
"If" statement returning blank gives downstream formula errors. 2

Top