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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top