Thread: Simple for you probably but hard for me

=IF(B2<1,B2*25.4),IF(AND(B2>=1,(B2<100),B2*2.54),IF(AND(B2>=100,(B2<10000),B2*.0254),IF(B2>=10000),B 2*.0000254)

Need to make a line that converts inches into other measurements but for whatever reason I am getting an error.

B2 is the block that Inches goes into and depending on how many it it depends on what measurement it turns into millimeters centimeters meters kilometers but when I put this formula into my block it doesn't work so please if you are a guru let me know what I am doing wrong.

Thanks in advance for any and all help