Formula with <= and >=

[paconovellino]

Hi,

Im hoping you can help me figure this out.

I have a formula that calculates if a value is greater than or less than other value. That part is simple . But what I want to do is to have a cell with a list value with <= => that modifies the formula one its changed.

I have uploaded an image to better explain my self. As you can see, on column C I have <= . Column K has this formula =IF(G2<=$J$2,1,0). So what is breaking my head is how to make the formula on column K change according column C.

Thanks

[FDibbins]

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

[TMS]

Not sure if this is what you have in mind but have a look at the attached sample workbook.

Regards, TMS

[paconovellino]

Sorry for uploading an image. I have attached an excel file.

thanks

[XOR LX]

Hi,

Try this in K2:

=SUMPRODUCT(COUNTIF(C2,"*"&{"<","=",">"}&"*")*(SIGN($J$2-G2)+{0,1,2}=1))

Works for the three comparators: <, > and =.

Regards

[ChemistB]

With your active cell being K2, go to Defined Names> New
Set up
Eval = EVALUATE(G2&$C$2&$J$2)

Then in K2
=IF(Eval,1,0) copied to the right. See attached sheet.

Evaluate is a MACRO 4 command and requires you save your file as an xls or xlsm.

[paconovellino]

Thank you so much for the help. It really solve my formula problem :D