IF not displaying what I expect

[Nite0wls]

Hi all, I have a problem with the IF function

The cell is a numeric value of 144289039636759
When the starting value of the number is 1 then I want only a part of the value 4428903963
If it is not then I expect the whole value.

This is the formula I use

=IF(LEFT(A13215,1=1),VALUE(MID(A13215,2,10)),A13215)

The VALUE(MID(A13215,2,10)) in itself returns the right value when I use it in a cell:
=VALUE(MID(A13215,2,10))

But the IF statement throws a #VALUE! error
I removed the VALUE but it still throws the error.

I know that the MID is original text manipulator but in many articles it is mentioned as to be able to use for numbers too

Is there a way to get part of the digits from a number to use?

 

[VoG]

Perhaps

=IF(LEFT(A13215,1)="1",VALUE(MID(A13215,2,10)),A13215)

 

[steve the fish]

This part LEFT(A13215,1=1)

Should be LEFT(A13215,1)="1"

 

[bschwartz]

That's what I was going to suggest.

I would just add =IF(LEFT(A13215,1="1"),VALUE(MID(A13215,2,10)),VALUE(A13215))

 

[Nite0wls]

Thanks all, the "1" part was the issue.

Ben thanks for the suggestion on that part as well.

 

[bschwartz]

You're welcome.