Create a formula based on a mathematical sign from another cell

I am trying to create a file that would show which criteria have been met based on targets. However, target here can be a minimum or maximum figure. Have a look at the attachment, the same result can be a success or failure depending on whether it should be less or more than a target. That relation is specified in column C. What formula should I use to make the status in column E automatically update when I change the relation in column C?

Set the DV values to ">=" and "<" (without quotes

then in E2

=IF(C2=">=",IF(B2>=D2,"Achieved","Failed"),IF(C2="<",IF(B3<D3,"Achieved","Failed")))

Obviously you can ad further conditions.

Create Name: Status

Refers to: =EVALUATE(Sheet1!$B2&Sheet1!$C2&Sheet1!$D2)

The formula in E2:

=IF(Status,"Achived","Failed")