if command

[chris832]

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.

 

[PCLIVE]

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]

yeah , your right. good idea

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