Decimal place if statement

**jacko311** · 11-09-2009, 10:36 AM

Is there a way to look at a cell that has a numeric value and create code that is based on the number of decimal places the imputed number has? For example if I enter 90.32 I want a particular result, but if i enter 1.0574 i would like a different result.

**DonkeyOte** · 11-09-2009, 10:40 AM

In formula terms - you could base on LEN of string less position of period delimiter to determine decimal significance, eg:

=MAX(0,LEN(A1)-FIND(".",A1&"."))

That said if you're using cell formatting to determine no. of decimals to display, ie

A1: 10.00

then you would need to use CELL function (specifically "format" subfunction)