Q:

Need 3 outcomes from IF statement

I have a list of names in excel which have a random number next to them in brackets, the numbers are 1 to 3 digits long. 
I was using the formula 
=IF(LEFT(RIGHT(B8,4),1)=("("),RIGHT(B8,3),RIGHT(B8,4)) 

to get rid of the first bracket and then 
=IF(RIGHT(LEFT(AX8,3),1)=")",LEFT(AX8,2),LEFT(AX8,3)) 

to remove the last bracket. 
This was working until I found a name with a 4 digit number in the brackets.
Is there a way to add another outcome to the if statement?

A:

The VALUE function will interpret bracketed numbers as negative but the ABS function will take care of that.
=ABS(VALUE(MID(A2, FIND("(", A2), 99)))

An additional bonus is that you end up with true numbers, not text that looks like a number.

