One way:


=IF(A1="Minimum",IF(A3=A2,"Yes","No"), IF(A1="Maximum",
IF(A3<=A2,"Yes","No"),""))

In article ,
mkerstei
wrote:

I have a worksheet, and if cell 1 contains the word "Minimum," I need it
to compare cells 2 and 3. I need it to run the equation in cell 4
=if(cell3=cell2,"yes","no")
But if cell1 contains the word Maximum, I need it to compare cells 2
and 3 and run the equation:
=if(cell3<=cell2,"Yes","No")
I think you can use the =find statement, but I cannot get it to work.
Any suggestions?