Do you want rounding?

=ROUND(5.1436,2)

If 5.1436 really should be transformed into 5.15, use:

=CEILING(5.1436,.01)


"RoseR" wrote:

Hello

I have managed to put a formular in that lets me add a percentage on cost to
an amount and still come out in price rather than a percentage, that is all
good but please can you help me by telling me now how i can make that price
round up so it is 5.14 rather than 5.1436

Many Thanx
--
Rose