Simplest way to know the decimals of a cell's value

[hglamy]

Hello there,

when values in a table a formated to be shown with 1 decimal,
is there a formula that can find out if there is a second decimal,
and if so, which one ?

Kind regards,

H.G. Lamy

 

[Ron Rosenfeld]

Hello there,

when values in a table a formated to be shown with 1 decimal,
is there a formula that can find out if there is a second decimal,
and if so, which one ?

Kind regards,

H.G. Lamy

Perhaps something like:

=E2=TRUNC(E2,1)

or

=E2=ROUND(E2,1)

or

=E2=INT(E2*10)/10


--ron

 

[Peo Sjoblom]

One way that will return all decimals


=TEXT(MOD(A1,1),"General")

 

[Bob Phillips]

HG,

This formula will check what you ask

=A1=ROUND(A1*10, 0)/10

It should be put in another cell, and it will return TRUE or FALSE. You
could use conditional formatting with this formula to just highlight the
values.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[hglamy]

Thank you all for your efforts and suggestions.

After trying out everything, I feel I may have put
the question wrong, however (had thought of
identifying "forecast values" by adding, and later
evaluating a hidden decimal to the actual value -
no good).

Since I am quite stuck with the problem after aq
lot of attemps, I dare to seek assistance a 2nd time.

I have put a description of what has to be achieved
on the website (under construction) "Enterplan.de",
Page G. Should anybody bother to have a look...

....your help is greatly appreciated,

kind regards,

H.G. Lamy

 

[Peo Sjoblom]

One possible way

=IF(ISNUMBER(F16),D16,NA())

or

=IF(F16="",NA(),D16)

using your example for 15 Oct 03