I have a client who would like Excel to round her values using the Swedish Rounding system
e.g. if the value is $1.33, it then rounds up to $1.35, but if the value is $1.32, it rounds down to $1.30
e.g. if the value is $1.37, it rounds down to $1.35, but if the value is $1.38, it rounds up to $1.40.
Does anyone know of a simple way that this can be achieved - and NOT as formatting.
Many thanks in anticipation!