I would like a formula that

S

Skip

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
 
R

Ron Rosenfeld

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
Click to expand...


A1: =IF(AND(B1>C1,B1>D1),"Yes","")
 
Top