Formula Error (false)

[gtd526]

Hello,

Im getting False from this formula.
R11
I want it to perform the subtraction. Both values are <0.
EXACT should only be done once for the entire formula. Then the AND for cell reference, followed by the calculation needed for those cells.

thanks.

NBA.xlsm
	B													O			R
9	-9													4			-13
10	9													-3.2
11	-8.5													-5.6			FALSE
12	8.5													-7.8
Favs

Cell Formulas
Range	Formula
O9:O12	O9	=IFERROR(VLOOKUP(A9,TeamRankings!$BW$3:$CB$33,6,0),"")
R9:R12	R9	=IF(EXACT(A9,AD9),IF(AND(B9<0,O9>0),B9-O9),IF(AND(B9<0,O9<0),B9-ABS(O9),""))

 

[AlphaFrog]

A right parenthesis was in he wrong place. Try this...

=IF(EXACT(A9,AD9),IF(AND(B9<0,O9>0),B9-O9,IF(AND(B9<0,O9<0),B9-ABS(O9),"")))

Also, you could omit the 3rd IF

=IF(EXACT(A9,AD9),IF(B9<0,B9-ABS(O9),""))

 

[gtd526]

A right parenthesis was in he wrong place. Try this...

=IF(EXACT(A9,AD9),IF(AND(B9<0,O9>0),B9-O9,IF(AND(B9<0,O9<0),B9-ABS(O9),"")))

Also, you could omit the 3rd IF

=IF(EXACT(A9,AD9),IF(B9<0,B9-ABS(O9),""))

I added your formula, but I still get FALSE.
I found that it was the EXACT function, I didn't have anything for the FALSE input, so it just said FALSE.
Thanks for your reply.