Help with Formula

[Guest]

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)

 

[Cutter]

Try this:

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

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

 

[Guest]

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

 

[Guest]

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

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

 

[Guest]

Awesome thanks!!! it works!

 

[Cutter]

You're welcome