Caroline,
That would not work if the value was an integer already. Maybe something like:
nRoundedValue = IIF( nValue > Int(nValue), nValue + 1, nValue)
Renoir
>How about int(3.0000001)+1
>
>>Hi all. I am looking for a roundup function that will always round to the next integer, i.e., 3.0000001 rounds to 4. I could swear that I've used such a function in VFP in the past but I sure can't find it today. Any suggestions?
>>
>>TIA and Happy Friday!