Quote:
Originally Posted by Weitz
I have a question:
I have a list of items that I need to assign a value to. They are labeled 1-6 with each number having a different value.
Is there a formula to use some sort of "If equal to 1 (or 2 or 3 etc) than show the corresponding value for 1 or 2 or 3 etc"? I can't seem to figure it out.
|
You could use either a look-up table or a nested boolean argument. Six items is a little high for nested if statements, but it will work. i.e if(cell=1,1 value, if(cell =2,2 value,if(cell=3,3 value,etc.