Formula - IF and VALUE function

areyno01

I'd like to figure out how to execute the following function.

If a cell contains certain text, fill in a numerical value in another cell. For example:

If cell A1 says "Request Type A" then fill in "3" in cell A2.

If cell A1 says "Request Type B" then fill in "5" in cell A2.

 

 

Nic Larsen

Here are few options depending on whether you are you building this formula out further with additional criteria. Both work though. These are based on the results going in an adjecent column. If you want the result directly below, then just swap out @row for the specific cell you want to look at:

1) =IF([Column A]@row = "Request Type A", 3, 5)

2) =IF([Column A]@row = "Request Type A", 3, IF([Column A]@row = "Request Type B", 5))

Paul Newcome

Depending on how many different options you have and how flexible you need those options to be (adding/deleting/etc.), another option would be to build out a table and use an INDEX/MATCH. This would keep you from having to dive into a long nested IF statement just to make a minor change then having to update all of the other rows.

 

Of course that is if you have a lot of options or your options/values could change frequently.