Sorry I just got the distinction "function that will always round to the next integer" I just assumed that if you had 3 then 4 was required.

>Renoir I know its late on a Friday and my brain is addled but doesn't int(3) return 3?
>
>>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!