| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Three possible outputs from an if statement.
=IF(C91="","",IF(C91="P/S","P/S","CLOSED"))
-- Gary''s Student - gsnu200909 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement to display 3 different outputs instead of 2 | Excel Worksheet Functions | |||
| If statement that outputs specific text if cell is not null | Excel Discussion (Misc queries) | |||
| =+SUM(S2:S36) outputs 19190fault | Excel Worksheet Functions | |||
| conditinal If statement with 3 outputs | Excel Worksheet Functions | |||
| Sumif outputs values | Excel Discussion (Misc queries) | |||
Hybrid Mode
