If a cell has certain text another cell will have a certain numeric value

[Godderz14]

I want to create what I think is an IF formula, so that if a cell has certain text then another cell will have a certain numeric value.

For Example if B6 contains 'MP35' then C6 will contain '125000' or if B6 contains '17-7PH' then C6 will contain '137000' and so on

can anyone help with this?

[josephteh]

C6=if(b6="mp35",125000,if(b6="17-7ph",137000,""))

[jeffreybrown]

Administrative Note:

Hi Godderz14 & Welcome to the forum.

We would love to help you with your query; however, the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly.

To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

Note: I've done this for you, but please give a little more thought about a better title the next time.

[jeffreybrown]

and so on

Hi Godderz14,

When you say, "and so on", that makes me think you will have more than just mp35 and 17-7ph.

If that is the case, you may want to create a lookup table.

https://www.contextures.com/xlFunctions02.html