Oops - make that

=TRUNC(A1,3)+0.0005*(VALUE(MID(A1,SEARCH(".",A1)+4 ,2))25)

"chartasap" wrote:

Hello,

would someone be able to help me build a function that would take the last
two digits in a value compare it then return a '0' or '5'. For example,

Column A
1.53138 (this value is the result of a formula =sum(c6/5873.05-c3) -- take
last two digits '38' compared to .00025. If it's less than .00025 then those
two last digits should become a 0 if greater than .00025 then it should be
'5'.
RESULT
1.5315
---------
1.53047 -- 1.5305
1.53002 -- 1.5300
1.52957 -- 1.5295

Thank you!