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
|