Results 1 to 5 of 5

Create a Formula where using different texts to display a value

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Create a Formula where using different texts to display a value

    I would like to create a formula that allows the destination cell display a number depending on a word that is typed in the source cell. The source cell and the destinating cell will remain the same two cells.

    example:A2=IF(A1="WORD1",1.5,0)

    If i type WORD1 in A1 (source cell) then A2 (destination cell) will display 1.5, but how do i make this formula work for a multiple of different words.

    example:A2=IF(A1="WORD1",1.5,0 IF(A1="WORD2",3.0,0 IF(A1="WORD3",2.5,0)))

    this formula doesn't work, but is basically what i am looking for the formula to do - WORD1 displays 1.5, WORD2 displays 3.0, WORD3 displays 2.5 etc where the source cell and the destinating cell remain the same two cells, it is just the word and its value that change

    Thank You
    Last edited by NBVC; 01-11-2010 at 12:07 PM. Reason: subject not discriptive enough

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