Approximation No

[shimaa01234]

I want to edit figure is higher than 0.5 to 0.5 and less deletes and keeps the rest of the figure
Such as:
70.9 to 7.5
The remaining 7.5 7.5
7.43 turns to 7.00

[LJMetzger]

Hi shimaa01234,

Try the following formula:

Please Login or Register  to view this content.

Lewis

[shimaa01234]

Wonderful solution
Thank you very much, Mr. " Lewis "

[FlameRetired]

Not sure I've interpreted correctly but this is one way to produce the values listed.

Row\Col	A	B	C
1	70.9	7.50	B1: =FLOOR(10^MOD(LOG(INT(A1)),1)+MOD(A1,1),0.5)
2	7.43	7.00