if command
 

i'm trying to make an if command work. i'm trying to make it look to see if a
number in a cell is between two numbers and then send it to another to be
multiplied . if the number is 1-11 look at one cell if its 12-23 look at
another and so on. my goal is to have something like this:

(a1+a1+b1=b1) * (look at what c cell number range is and send it to the
corresponding cell to be multiplied)

i have to link what i multiply to this cell and can't be in the formula
because the number i multiply it by is its own formala and constantly
changes. if that makes any sense to anybody.

thanks in advance for anybody with any ideas.

if command
 

You could use nested IFs as long as it doesn't exceed 7.

=(A1+A1+B1)*IF(C1<=11,"CorrespondingCell1",IF(C1<= 23,"CorrespondingCell2"))

Otherwise, you should probably look into VLOOKUP.

HTH,
Paul

--

"chris832" wrote in message
...
i'm trying to make an if command work. i'm trying to make it look to see
if a
number in a cell is between two numbers and then send it to another to be
multiplied . if the number is 1-11 look at one cell if its 12-23 look at
another and so on. my goal is to have something like this:

(a1+a1+b1=b1) * (look at what c cell number range is and send it to the
corresponding cell to be multiplied)

i have to link what i multiply to this cell and can't be in the formula
because the number i multiply it by is its own formala and constantly
changes. if that makes any sense to anybody.

thanks in advance for anybody with any ideas.

if command
 

yeah , your right. good idea

"PCLIVE" wrote:

You could use nested IFs as long as it doesn't exceed 7.

=(A1+A1+B1)*IF(C1<=11,"CorrespondingCell1",IF(C1<= 23,"CorrespondingCell2"))

Otherwise, you should probably look into VLOOKUP.

HTH,
Paul

--

"chris832" wrote in message
...
i'm trying to make an if command work. i'm trying to make it look to see
if a
number in a cell is between two numbers and then send it to another to be
multiplied . if the number is 1-11 look at one cell if its 12-23 look at
another and so on. my goal is to have something like this:

(a1+a1+b1=b1) * (look at what c cell number range is and send it to the
corresponding cell to be multiplied)

i have to link what i multiply to this cell and can't be in the formula
because the number i multiply it by is its own formala and constantly
changes. if that makes any sense to anybody.

thanks in advance for anybody with any ideas.