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?


--
mkerstei
------------------------------------------------------------------------
mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688
View this thread: http://www.excelforum.com/showthread...hreadid=392939