Three possible outputs from an if statement.
 

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

Three possible outputs from an if statement.
 

=IF(C91="","",IF(C91="P/S","P/S","CLOSED"))

--
Gary''s Student - gsnu200909

Three possible outputs from an if statement.
 

Except it should be =If(C91="","Open"... I think.

"Gary''s Student" wrote:

=IF(C91="","",IF(C91="P/S","P/S","CLOSED"))

--
Gary''s Student - gsnu200909

Three possible outputs from an if statement.
 

You are correct!
Thanks for the help
--
Gary''s Student - gsnu200909


"Allen" wrote:

Except it should be =If(C91="","Open"... I think.

"Gary''s Student" wrote:

=IF(C91="","",IF(C91="P/S","P/S","CLOSED"))

--
Gary''s Student - gsnu200909