Forum 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

Comments: 2 Responses to “How Do I Get Cell C3 To Equal a Specific Number Depending On What B3 Is?”

    8/21/13 @ 2:41 pm

    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
      8/21/13 @ 3:14 pm

      Thanks for the help Gary!

Comments Closed.