K
Karl
I can't seem to round a figure to the nearest 50 or 100.
Example: If I had a figure 210.00 I want this to round to
250.00 or if I had a figure 190.00 I want this to round
up to 200.00.
Another example 260.00 rounded to 300.00
Seems so simple but I can't seem to find a way.
Mabey Logic function?
I've tried Roundup ceiling, floor, and round functions
but can't seem to get it right.
Any suggestions would be greatly appreciated.
Karl
Example: If I had a figure 210.00 I want this to round to
250.00 or if I had a figure 190.00 I want this to round
up to 200.00.
Another example 260.00 rounded to 300.00
Seems so simple but I can't seem to find a way.
Mabey Logic function?
I've tried Roundup ceiling, floor, and round functions
but can't seem to get it right.
Any suggestions would be greatly appreciated.
Karl