Zend certified PHP/Magento developer

Excel FIND Error

I have the formula to multiply the specific value from cell A2

example: In A2, I want to multiply the value before “.” with eleven while at the same time I also want to add value after “.”

I came up with

=11*LEFT(A1,FIND(".",A1)-1)+RIGHT(A1,LEN(A1)-FIND(".",A1))

It works pretty fine if it does have . in between, but when there is a single value eg, 1-10, etc it throws error #VALUE!

All I want if there is a value 2 in cell A2 it should return 22 (2*11=22) instead of error, but if there is 2.5 for instance, it should first multiple 11*2 then adds up remaining 5 (27) in other words it will multiply value before point, then adds up value after point