View Single Post
  #1   Report Post  
jbsand1001
 
Posts: n/a
Default Compare 2 cells values with one IF statement

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