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
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
Hi shimaa01234,
Try the following formula:
LewisPlease Login or Register to view this content.
Wonderful solution
Thank you very much, Mr. " Lewis "
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.50B1: =FLOOR(10^MOD(LOG(INT(A1)),1)+MOD(A1,1),0.5) 2 7.43 7.00
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks