Only display all numbers before the “.”

[rlsublime]

I am trying to create an if statement that will only display all the values before the “.”. If there is no “.”, then simply display the number. Basically I am trying to exclude every value after the “.”, if there is one. Is there a formula that could accomplish this or would I have to create a macro to accomplish this.
101.12
10001.1
1000
99.1
94.123

[tigeravatar]

rlsublime,

Give this a try:

Please Login or Register  to view this content.

[ATLGator]

Or try:
=IF(ISERROR(FIND(".",A1,1)),A1,LEFT(A1,FIND(".",A1,1)-1)*1)

Where A1 is the value you are evaluating

[ATLGator]

Just tested tigeravatar's solution - it's a lot simplier than mine.