Sage 100

Is there anything available in VI to force a round UP to the nearest whole value, like Crystal has, vs. the normal PRC to round down/up to the nearest value?

Perhaps a calculation to turn the field into a whole number then add one??? Or just add 50 cents to the number, then do a PRC round. What number do you want returned if the original number is a whole value? If it is one and you want one, then add 49 cents before rounding.

If N is the number you can do: PRC(N+.4999, 0). This will force it to round up. In my example there are no decimal places. Adjust as you need to. The number of trailing 9s needed depends on the expected decimal precision of N to begin with. I think that works.

Thank you both! So simple and so genius!