8/21/13
2:37 pm

# 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!