| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embeded IF Statement
The logic of my statement is;
IF N16$K$10, AND R160 then Yes Else No and I'm not sure how to write it in Excel. Can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Embeded IF Statement
=IF(AND($N$16$K$10,$R$160),"Yes","No")
Regards, Alan. "Rob M" <Rob wrote in message ... The logic of my statement is; IF N16$K$10, AND R160 then Yes Else No and I'm not sure how to write it in Excel. Can anyone help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Embeded IF Statement
IF(AND(N16$K$10,R160),"Yes","No")
"Rob M" wrote: The logic of my statement is; IF N16$K$10, AND R160 then Yes Else No and I'm not sure how to write it in Excel. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More than 7 embeded if statements | Excel Worksheet Functions | |||
| Embeded ComboBox | Excel Worksheet Functions | |||
| Parent of the embeded excel | Excel Discussion (Misc queries) | |||
| protect embeded object | Excel Discussion (Misc queries) | |||
| protect embeded object | Excel Worksheet Functions | |||
Linear Mode
