Hi, I have a formula that says =if(A1>A2,"True","False"). However, I want the ability for the user to change the sign in an other cell. So let's say in cell B1 they can enter ">" or "<". I want to write a formula something like this =if(A1&B1&A2,"True","False"). This does not work. How can I do this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Link to "<" or ">" in an excel formula
Eric W
MrExcel MVP
- Joined
- Aug 18, 2015
- Messages
- 13,332
Welcome to the Board.
There's really no good way to do this, but there are several options. You could come up with a more complicated formula, like this:
=IF(AND(B1="<",A1< A2),"True",IF(AND(B1=">",A1>A2),"True","False"))
You could use COUNTIF like this:
=IF(COUNTIF(A1,B1&A2),"True","False")
Or you could use the EVALUATE function which requires some heroic efforts using the Name Manager, and turns your workbook into a macro-enabled workbook.
Or you could actually write a User-Defined Function in VBA which would be easiest to understand.
Let us know if any of these ideas work for you.
There's really no good way to do this, but there are several options. You could come up with a more complicated formula, like this:
=IF(AND(B1="<",A1< A2),"True",IF(AND(B1=">",A1>A2),"True","False"))
You could use COUNTIF like this:
=IF(COUNTIF(A1,B1&A2),"True","False")
Or you could use the EVALUATE function which requires some heroic efforts using the Name Manager, and turns your workbook into a macro-enabled workbook.
Or you could actually write a User-Defined Function in VBA which would be easiest to understand.
Let us know if any of these ideas work for you.
Last edited:
Upvote
0
Similar threads
- Locked
- Question
- Solved
