Decimal and match excel formulas questions.

[04_launder_spirals]

Hello!

For the fisrt table: Is there a formula that will return a blank cell instead of #value! when a number doesn't have a decimal point? This is the formula that I have so far =LEN(RIGHT(A2,LEN(A2)-FIND(".",A2)))

For the second table: Is there a formula that will find if Column A and B values match and return a flase is numbers have more that 4 decimal points


Thank you!!



First table

Column A	Column B
2.33	2​
2.444	3​
3.4444	4​
2	#VALUE!​

Second table

Column A	Column B	Column C
2.33​	2.33	2​
4.555​	2.444	3​
3.4444​	3.4444	4​
2	2
4.55555​	4.55555	​

 

[pecoflyer]

Hi please post a sample sheet. Pictures are useless. Thx

 

[bosco_yip]

Try,

=TEXT(LEN(A2)-FIND(".",A2&"."),"0;;;")