ExcelBanter - Embeded IF Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Embeded IF Statement (https://www.excelbanter.com/excel-worksheet-functions/168892-embeded-if-statement.html)

Rob M

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?

Alan

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?

Teethless mama

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?

All times are GMT +1. The time now is 11:13 PM.