Compare 2 cells values with one IF statement

[jbsand1001]

I am trying to find out if it is possible to comapre 2 cells with one of the
cells I having 2 different values to compare. For example

I am need for it to look in J2 and say if J2= 20 it will add 136 but if J2 =
40 it will add 165.


below is what I have so far but I am trying to find out if it can look at a
second argument in j2?
=IF(B2="something",J2+136,M2+0)


Any guidance would be greatly appreciated.

Judd

[Gary's Student]

In your formula, try replacing
J2+136
With
(J2=20)*136+(J2=40)*165

This should return the correct value and return zero if J2 does not equal
either 20 or 40.

--
Gary's Student


"jbsand1001" wrote:

> I am trying to find out if it is possible to comapre 2 cells with one of the
> cells I having 2 different values to compare. For example
>
> I am need for it to look in J2 and say if J2= 20 it will add 136 but if J2 =
> 40 it will add 165.
>
>
> below is what I have so far but I am trying to find out if it can look at a
> second argument in j2?
> =IF(B2="something",J2+136,M2+0)
>
>
> Any guidance would be greatly appreciated.
>
> Judd
>
>