Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a row of cells (i.e., L14:Q14) on Worksheet 1 whose possible values
are either: 0, 1, 3, 5, "false". On Worksheet 2, for a particular cell, I'd like to return a value of "X" if the values in row 14 of Worksheet 1 are either a "5" or "false" (note, they have to all be either a 5 or false), otherwise, if they are not all either a "5" or "false" then I'd like to return a blank, " " on Worksheet 2. Thanks in advance for any advice. Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help w/ the PROPER function | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Discussion (Misc queries) |