December 27, 200421 yr Newbies Could you please help me with this calculation: I need to round UP [up only] to nearest .05. i.e. 6.63 to 6.65 0r 6.66 to 6.70. Thanks. Russ PS sorry if there is double post on this topic.
December 27, 200421 yr I've never used v.6, so I don't know if it has a Ceiling function. If not, try this (haven't tested it, though) Int( 20 * InputNumber) / 20 + 0.05 * (Mod(InputNumber, 0.05) > 0)
Create an account or sign in to comment