LEFT() + RIGHT() + IF() not working in conjunction

Hi All,

Only fresh to this forum.

I'm trying to have my excel read the digits of a cell, and if it is between a certain value it is to produce a calculation, if not, its to produce a different calculation.

I want to be able to put in two dimensions (mm x mm) and it will calculate the value based on this. The maximum dimension I want it to calculate at is 800mm, and the cell will only take values like 600x500; 700x200; 900x800
(I will worry about a LEN() input after I actually get this part working first)
eg of the formula
A1: 700x600
=IF(AND(LEFT(A1,3)<800,RIGHT(A1,3)<800), "Good", "Bad")

So what should happen is that the Formula breaks out the first three digits of cell A1, and checks if its less than 800, it also checks the final three digits of cell A1, and checks if its less than 800. If they are less, it shows "good", and shows "bad" if it's false.

At the moment I can't even get it to correctly output the Good or Bad text when I change the A1 cell to any other 7 character long value [it's spitting out "Bad" in this case, even though its obvious to see that both 700 & 600 is less than 800]
Why is this? I had thought maybe it is outputting the LEFT() & RIGHT() as text and it cant figure out if its less than the value, but I can do other calculations with it so I don't know what the issue is. I have checked and I have auto-calculate on
Can anyone figure it out?

Any help would be much appreciated

Thanks John, the *1 worked!
Don't know how I didn't think of it - I was even trying ABS() haha