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
Bookmarks