ExcelBanter - I would like a formula that

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

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

- - I would like a formula that (https://www.excelbanter.com/excel-worksheet-functions/270919-i-would-like-formula.html)

Skip[_2_]

I would like a formula that

will print an answer Yes in a cell.
B1=8
C1=7
D1=6

If B1 is C1 and B1 is than D1 then answer Yes in A1.
Is this possible?

Any help is appreciated.
Skip

Ron Rosenfeld[_2_]

I would like a formula that

On Thu, 29 Sep 2011 13:34:04 -0700 (PDT), Skip wrote:

will print an answer Yes in a cell.
B1=8
C1=7
D1=6

If B1 is C1 and B1 is than D1 then answer Yes in A1.
Is this possible?

Any help is appreciated.
Skip

A1: =IF(AND(B1C1,B1D1),"Yes","")

All times are GMT +1. The time now is 02:57 AM.