Results 1 to 3 of 3

Comparison:What is the formula to do this?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-12-2006
    Posts
    106

    Comparison:What is the formula to do this?

    This is probably as easy as it gets, but how do I do this:

    I have three columns, A, B and C
    The formula I am asking should fill C based on A and B

    A and B gets info from external source, it doesn't matter from where
    C is "W" if A > B
    C is "T" if A = B
    C is "L" if A < B

    so for example
    A = 3, B = 4, C = L
    A = 4, B = 4, C = T
    A = 5, B = 4, C = W

    What is the formula to do this?


    edit. A little extension to this:
    There is also column D
    If C = W, D = 2
    If C = T, D = 1
    If C = L, D = 0

    Should be even easier.

    And please, answer for either English or Finnish version.
    Last edited by Jaymond Flurrie; 10-10-2006 at 10:44 AM.

Thread Information

Users Browsing this Thread

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

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