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))