Multiple values

[bassls]

I want to be able to enter 1 of 4 specific values into cell B3 and return a different specific value to cell D3. For example, if I enter .99 into B3, I want to get 1.965 in D3. Each of the original 4 in B3 has only 1 possible answer for D3.

Thanks

 

[Joe4]

You can use an imbedded IF statement or the VLOOKUP function:

If Statement in cell D3:
=IF(B3=.99,1.965,IF(B3=value2,returnvalue2,IF(B3=value3,returnvalue3,IF(B3=value4,returnvalue4,""))))

Check out Excel's help for details and example using VLOOKUP.

 

[bassls]

Thanks, That worked great.