MacMost Q&A Forum • View All Forum Questions • Ask a Question

How Do I Get Cell C3 To Equal a Specific Number Depending On What B3 Is?

I am wanting to get specific value in column c which is dependent on the text in column B. For instance, if cell B3 is XYZ, then I want number 600 to show up in Cell C3. IF cell B3 is ABC, then I want number 1200 to show up in Cell C3?
—–
Matt

Replies: 2 Replies

    Gary Rosenzweig
    12 years ago

    To do that, you need to use the IF function.
    For instance, if you want to check to see if B3 is a 1 or a 2, and then put 600 or 1200 in a cell based on that, you would use this in the cell:
    =IF(B3=1,600,1200)
    That would give you a 600 if B3 is a 1, and 1200 if it is anything else.
    If you are looking for a string, like literally "XYZ" then you would use quotes:
    =IF(B3="XYZ",600,1200)
    Now if it gets more complex, say you have more than two options, then you may want to go to the LOOKUP function. See http://macmost.com/using-the-lookup-function-in-numbers.html

      Matt
      12 years ago

      Thanks for the help Gary!

Comments are closed for this post.