Using Indirect with a ">=" as an argument

[nigelk]

Hi

In A1 I have 10
In B1 I have 20

In cell C1 the user enters either ">=" or "<="
Using a formula it would be =A1>=B1

But I need to replace the hard coded >= with whatever the user enters in C1

Can anyone help?

Thanks,Nigel.

 

[Jonmo1]

There's no function that can do that I'm afraid.

But if it's 'really' just those 2 possible operations >= or <= then you can just do this

=IF(C1=">=",A1>=B1,A1<=B1)

I can see nesting maybe 4 or 5 possible operations to use, any more than that I'd suggest a VBA solution.

 

[nigelk]

Thanks for your help. I'll have to it with vba.

Nigel.

 

[Rick Rothstein]

This formula would return 1 if the relationship is true and 0 if false...

=COUNTIF(A1,C1&B1)

If you actually need to see TRUE or FALSE, then you can use this formula...

=IF(COUNTIF(A1,C1&B1),TRUE,FALSE)

 

[wideboydixon]

If it's a one-off then there's a sneaky way to use "Define Name" on the formulas tab:

Book1
	A	B	C	D
1	10	20	<=	TRUE
Sheet1

Cell Formulas
Range	Formula
D1	=Answer1

Named Ranges
Name	Refers To	Cells
Answer1	=EVALUATE(Sheet1!$A$1&Sheet1!$C$1&Sheet1!$B$1)

WBD

 

[Marcelo Branco]

Maybe...

=SUMIF(A1,C1&B1)=A1

M.

 

[nigelk]

You guys are so ingenious!

Thanks.Nigel

 

[Rick Rothstein]

This formula would return 1 if the relationship is true and 0 if false...

=COUNTIF(A1,C1&B1)

If you actually need to see TRUE or FALSE, then you can use this formula...

=IF(COUNTIF(A1,C1&B1),TRUE,FALSE)

Actually, I like Marcelo's idea for forcing TRUE/FALSE; here is how it would be applied to my formula approach...

=COUNTIF(A1,C1&B1)=1