Hi, I have spreadsheet where I want to compare two columns and set up
conditions to get the answer I want. There are 4 logic tests I need done to
get the answer I need for each row.

Here is what I need to do: can someone help me with the formula??

(If the value in Cell G2 is less than or equal to 100 AND the value in Cell
I2 is equal to 1 enter 73) (If the value in Cell G2 is less than or equal
too 100 AND the value in Cell I2 is greater than 1 enter 115) (If the value
in Cell G2 is greater than 100 AND the value in Cell I2 is equal to 1 enter
130) (If the value in Cell G2 is greater than 100 AND the value in Cell I2
greater than 1 enter 150)
--
Kim

Try this:

=if(and(G2<=100,I2=1),73,if(and(G2<=100,I21),115, if(and(G2100,I2=1),130,if(and(G2100,I21),150,"" ))))

It returns a "blnk" cell if none of your conditions are met: ie. I2<1


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=512770

=IF(AND(G2<=100,
I2=1),73,IF(AND(G2<=100,I21),115,IF(AND(G2100,I2 =1),130,IF(AND(G2100,I21),150,0))))
Note: if none of the criteria is met, 0 is entered.
--
Kevin Vaughn


"Kim CB" wrote:

Hi, I have spreadsheet where I want to compare two columns and set up
conditions to get the answer I want. There are 4 logic tests I need done to
get the answer I need for each row.

Here is what I need to do: can someone help me with the formula??

(If the value in Cell G2 is less than or equal to 100 AND the value in Cell
I2 is equal to 1 enter 73) (If the value in Cell G2 is less than or equal
too 100 AND the value in Cell I2 is greater than 1 enter 115) (If the value
in Cell G2 is greater than 100 AND the value in Cell I2 is equal to 1 enter
130) (If the value in Cell G2 is greater than 100 AND the value in Cell I2
greater than 1 enter 150)
--
Kim

Again Awesome!! You guys save the day
--
Kim


"Kevin Vaughn" wrote:

=IF(AND(G2<=100,
I2=1),73,IF(AND(G2<=100,I21),115,IF(AND(G2100,I2 =1),130,IF(AND(G2100,I21),150,0))))
Note: if none of the criteria is met, 0 is entered.
--
Kevin Vaughn


"Kim CB" wrote:

Hi, I have spreadsheet where I want to compare two columns and set up
conditions to get the answer I want. There are 4 logic tests I need done to
get the answer I need for each row.

Here is what I need to do: can someone help me with the formula??

(If the value in Cell G2 is less than or equal to 100 AND the value in Cell
I2 is equal to 1 enter 73) (If the value in Cell G2 is less than or equal
too 100 AND the value in Cell I2 is greater than 1 enter 115) (If the value
in Cell G2 is greater than 100 AND the value in Cell I2 is equal to 1 enter
130) (If the value in Cell G2 is greater than 100 AND the value in Cell I2
greater than 1 enter 150)
--
Kim

Awesome thanks!!! it works!


"Cutter" wrote:


Try this:

=if(and(G2<=100,I2=1),73,if(and(G2<=100,I21),115, if(and(G2100,I2=1),130,if(and(G2100,I21),150,"" ))))

It returns a "blnk" cell if none of your conditions are met: ie. I2<1


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=512770

You're welcome


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=512770