Rounding up suing Quattro Pro S.E. v1.0 to the nearest quarter

[LW Porter, Jr.]

Hi! My name is LW Porter and I have problem with the old Quattro Pro
v1.0. Unfortunately I am stuck with this old version of Quattro Pro, and
I am trying to formulate a spreadsheet of premium rates based on
different coverage amounts. So for say a $28000 policy the premium would
be say $252.80, but the final cost would be rounded up to the nearest
quarter. In Excel I would use the @CEILING function. But this version of
Quattro Pro does not have a corresponding function. So converting is out
of the question. I know that I can take the resulting calculate premium
and divide by 25 then round to that amount to decimal places,and then
multiply by 25 to get to the nearest quarter. But this does not always
result in rounding up to the nearest quarter. Take the value $252.80 for
exaample. When I use the formula @round(252.8/25,2)*25, I get 252.75.
But rounding up should result in 253.00, since the 252.8 is obviously
greater than 252.75. So the question is how do form a formula that will
result in all values rounding up to the nearest quarter? Do I use @if
function or what? Hopefully someone out there can help me with this
problem. I thank all who respond!

Regards,
LW Porter
lwpj...@alaska.net

[Marcel Joubert]

Greetings from Cape Town

Simply add in a test to see whether the rounding has rounded up or down,
and if it has
rounded down, then add in 25c. Following formula works.

D E
8 252.65
@IF(@ROUND(D8/25,2)*25<D8,@ROUND(D8/25,2)*25+0.25,@ROUND(D8/25,2)*25)
9 252.65 252.75
10 252.75 252.75
11 252.80 253.00
12 253.10 253.25

Possibly you could help us with a problem of our own. We are also
reluctant users of
outdated Quattro software (ver 4.0 DOS and ver 1.0 Windows) stuck in a
cruel time warp
because of a vast library of spreadsheet history which we cannot abandon
unless we have
a seamless upgrade path. I have searched high and low for Quattro
upgrade information
and newsgroups (Corel sites, Borland sites, Novell sites) but can find
no information
to assist. Do you know of any newgroups for stranded Quattro users ?

We are also starting to have VGA driver problems running Quattro 4.0 DOS
in Windows 95
and are looking for sites to get updated Quattro VGA drivers for Windows
95. Any
suggestions ?

Thanks and good luck with the rounding !

P.S. How's Alaska ? Brrrrrrrr ?