=Right formula question

[johnny52]

I have two columns .........in cell a1 the number 148.5 in cell b1 the formula =RIGHT(a1,1) the result 5 I'm fine with that
now in cell a2 I have the number 148.0 in b2 the formula =RIGHT(a2,1) the results I'm getting is 8 I want it to be 0

what am I doing wrong

Thanks everybody as always

 

[Misca]

Sounds like your .0 is only cell formatting. Try using TEXT(A2,"0.0") instead of just A2 and see if that takes care of your problem.

 

[cooper645]

If you need the value this should work

=RIGHT(A1-INT(A1),1)

If there is more than 1 digit after the decimal you will have issues with it though.

 

[cooper645]

This works also regardless of how many digits after the decimal point.

The iferror applies when it is ".0" as that will return an error depending on format of column A

=IFERROR(MID(A1,SEARCH(".",A1,1)+1,LEN(A1)),0)

 

[johnny52]

Thanks your second response works fine for my needs

Thanks

 

[johnny52]

=IFERROR(MID(A1,SEARCH(".",A1,1)+1,LEN(A1)),0)

I used yours but this later response above,handles my needs too.Thank you as well