Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"IF" type formula
How do you create the formula for the following:
If cell X has a certain character (1,2,3,4,5,6) then I want cell Y to be populated with a determiend value based on X (for example 1=20%, 2=40%, 5=75%). THank you. |
#2
|
|||
|
|||
Using VLOOKUP is one way. For example:
=VLOOKUP(A1,{1,0.2;2,0.4;5,0.75},2,0) HTH Jason Atlanta, GA -----Original Message----- How do you create the formula for the following: If cell X has a certain character (1,2,3,4,5,6) then I want cell Y to be populated with a determiend value based on X (for example 1=20%, 2=40%, 5=75%). THank you. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Formula to extend a string of type AAA001 | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) |