Results 1 to 2 of 2

Building a function completely from cell values

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2010
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2007
    Posts
    1

    Building a function completely from cell values

    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.
    Last edited by JConn; 01-20-2010 at 05:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1