On Dec 21, 7:56*am, Sarah_Lund
wrote:
If the 3rd digit after the decimal is not a zero,
I need to round up the 2nd digit, otherwise leave
the number as is
Examples:
4.240 would be 4.24
4.241 would be 4.25

Caveat emptor: it is not clear what you want to do with 4.2405, for
example. A literal interpretation would say that you want 4.24. But
perhaps you mean "if the 3rd digit after the decimal point after first
rounding to 3 decimal places". It would behoove you to test any
solution with 4.2405 to be sure it is giving you what you want.