I NEED A FORMULA THAT WILL LOOK AT CELL A1 AND CELL A2 TO DETERMINE WHICH
NUMBER IS LARGER. iF A1 IS GREATER THAN A2, THEN TAKE A1 AND SUBTRACT A2 AND
ADD 11. IF A2 IS LARGER THAN A1, THEN TAKE A2 AND SUBTRACT A2 AND ADD 11. I
RECEIVED A RESPONSE A FEW MINUTES AGO, BUT WAS UNABLE TO OPEN IT. HELP,
PLEASE

THANKS

DAN A.

Try..Copied form the previous post

=MAX(A1:A2)-MIN(A1:A2)+11

PS: Please avoid upper case letters which is difficult to read...

If this post helps click Yes
---------------
Jacob Skaria


"Dan A." wrote:

I NEED A FORMULA THAT WILL LOOK AT CELL A1 AND CELL A2 TO DETERMINE WHICH
NUMBER IS LARGER. iF A1 IS GREATER THAN A2, THEN TAKE A1 AND SUBTRACT A2 AND
ADD 11. IF A2 IS LARGER THAN A1, THEN TAKE A2 AND SUBTRACT A2 AND ADD 11. I
RECEIVED A RESPONSE A FEW MINUTES AGO, BUT WAS UNABLE TO OPEN IT. HELP,
PLEASE

THANKS

DAN A.

What's wrong with the answers in your previous post?

=ABS(A1-A2)+11


Mike

"Dan A." wrote:

I NEED A FORMULA THAT WILL LOOK AT CELL A1 AND CELL A2 TO DETERMINE WHICH
NUMBER IS LARGER. iF A1 IS GREATER THAN A2, THEN TAKE A1 AND SUBTRACT A2 AND
ADD 11. IF A2 IS LARGER THAN A1, THEN TAKE A2 AND SUBTRACT A2 AND ADD 11. I
RECEIVED A RESPONSE A FEW MINUTES AGO, BUT WAS UNABLE TO OPEN IT. HELP,
PLEASE

THANKS

DAN A.