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
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