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

  • Thread starter Thread starter hglamy
  • Start date Start date
H

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
 
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
Click to expand...

Perhaps something like:

=E2=TRUNC(E2,1)

or

=E2=ROUND(E2,1)

or

=E2=INT(E2*10)/10


--ron
 
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)
 
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
 
One possible way

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

or

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

using your example for 15 Oct 03
 
Back
Top