Caroline,

Sure, but Mark asked how he could round it up to 4 if it was larger than 3. Maybe I'm the one who's brain is addled? Isn't 3.0000001 larger than 3?

Renoir

>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!