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
Bookmarks