IF< Symbol < based on cell

[giorgiokatr]

if(C5<C6;TRUE;FALSE)

can the symbol < based on a cell that contains it example E1
i want to insert the symbol < or > in a cell and the if to change < or > based on this
i tried this but no luck

if(C5&"E1"&C6;TRUE;FALSE)

 

[NARAYANK991]

Hi Giorgio ,

I don't think so , but you never know , there may be some possible way to do it.

What I do know is that the SUMIF function takes a criteria parameter , and you can make use of it this way :

=SUMIF(A1,B1 & C1)

where A1 has a value , B has the symbol < , and C1 has a check value.

This will return the value in A1 is the condition is satisfied , and 0 otherwise. Naturally , if A1 contains 0 , this is of no use ! In such a case , you can use the COUNTIF function. Play around with this , and see if it helps.

Narayan

 

[giorgiokatr]

thanks NARAYANK991!
Yes Sumif can take this i use it like "<="&B1 or "C1"&B1
but unfortunately IF seems to not working
i am using a complex formula to get the second, third vlookup values etc
something like this
=IFERROR(INDEX($A$1:$A$20;SMALL(IF($B$1:$B$20<$E$1;ROW($A$1:$A$20));F1));"")

and was trying to make the <$E$1 conditional but no big deal!
Thanks a million for your time to answer!

 

[NARAYANK991]

Hi Giorgio ,

See if you can make use of this technique :

Define a named range , say XXX , which has the following formula in the Refers To box :

=EVALUATE(Sheet1!A1 & INDIRECT("B1") & Sheet1!C1)

Now , in your worksheet , if you put in an used cell , the formula =XXX , it will return the value FALSE or TRUE depending on the data in A1 , the operator ( < , <= , > , >= , <> ) in B1 , and the check value in C1.

Narayan

 

[giorgiokatr]

thanks i ll give it a try!