Hello - I'm trying to get the following formula to show either a single number (i.e. or, where there is a variance (above/below 2/3) show a number with the variance (i.e. 6(2) ):
IF(AND(D2>2,D3<3,OR(D2<3,D3>2)),(D2+D3)&"("&(D2-D3)&")",(D2+D3))
Sadly, the results for D2=4, D3=4 are 8(0) where the result should be 8
If I use the same formula but swap the true and false statements (IF(AND(D2>2,D3<3, OR(D2<3,D3>2)), (D2+D3), (D2+D3)&"("&(D2-D3)&")") the brackets disappear, but even if D2=3 and D3=2 - which should show 5(1) :duh:
I have no idea what I've done wrong so any help would be hugely appreciated!
[INDENT]
PS the range in each cell (i.e. D2) is 1-4 which results with one of the following: 8, 7, 6, 6(2), 5(1), 5(3), 4, 2, 1
[/INDENT]