One way:


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

In article <[email protected]>,
mkerstei <[email protected]>
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?