MacMost Q&A Forum • View All Forum QuestionsAsk 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

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

    11 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
      11 years ago

      Thanks for the help Gary!

Comments Closed.