Is it possible to build an Excel function completely from cell values in a worksheet?
I have data in three columns. Column one contains a number, column two contains a comparison operator (i.e. <, >, <=, >=, or =) and column three contains another number. I would like to be able to dynamically build a function to combine the data in all three columns and evaluate it to either True or False. I have not been able to get Excel to see column 2 as a comparison operator.
For example:
Column 1 | Column 2 | Column 3
9 >= 2
55 < 33
42 = 15
The first row should evaluate to TRUE, while row two and three evaluate to FALSE.
Thank you for any help you can provide.
Bookmarks