How about this:

=ROUNDDOWN(A1-.001,0)

HTH,
Elkar


"Dale" wrote:

I am trying to round down a number to the next whole number. Example 9.2
would round down to 9, 6.0 would round down to 5.0