if statement with Logic_Test in another cell

[cidfidou]

Hi Guys,

Is it possible to use a if statement with the Logic_Test is another cell?

For example in A1 I have entered = >10

I am trying: =if(12=A1,1,0) but doesn't work ...

Any help would be really appreciated

 

[etaf]

it will not see >10 as a value and so
a1=12 will not see >10 as 12 only as text

you could possibly do something with the symbol and number and extract from the cell
BUT what are the possible combinations

 

[cidfidou]

Hi Etaf

thanks for your answer.. basically I am trying to assign categories to a range of data for which I will have different criteria i.e.and i don't want to hardcode the ">X' in the if statement.. the idea would be to change the criteria cell and not the formula,,, is there a way around? thanks

 

[etaf]

will it always be > only with a number

what is the criteria cell ?
A1
not sure i understand

does this work ?



12=a1
is that the bit that you dont want to change

if A1 is allways
>
=MID(A1,2,10)*1

=IF(MID(A1,2,10)*1 = 12, 1,0)

 

[cidfidou]

thanks for helping.. the criteria cell is A1 and could be: >10, <10, >5..

What I am trying to do is to reference A1 as the logical test in a if statement .... this way I could update A1 and not the if statement if that make sense...

so in the example above in A1 the criteria is >5, how can we reference the criteria in A1 to check if lets say 10 is '>5'.. thanks again for ur help

 

[cidfidou]

i found a way around with countif

if(countif(A2,A1)=1,1,0)

 

[etaf]

cool solution

 

[Scott Huish]

If you are just returning 1 and 0, TRUE and FALSE can be coerced to 1 and 0 by doing math on it, usually adding 0.

=(COUNTIF(a2,a1)=1)+0

will return the same value as your formula with 1 less function.