Help with Formula

[Kim CB]

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

[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

[Kevin Vaughn]

=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.
--
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

[Kim CB]

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


"Kevin Vaughn" wrote:

> =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.
> --
> 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

[Kim CB]

Awesome thanks!!! it works!


"Cutter" wrote:

>
> 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
>
>
> --
> Cutter
> ------------------------------------------------------------------------
> Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
> View this thread: http://www.excelforum.com/showthread...hreadid=512770
>
>

[Cutter]

You're welcome