How do I simulate Excel's Ceiling/Floor Functions in VBA ...- Tek-Tips

Examples Ceiling(2.5, 1) equals 3 Ceiling(2.5) equals 3 Ceiling(-2.5, -2) equals -4 Ceiling(-2.5, 2) equals -2 Ceiling(1.5, 0.1) equals 1.5 Ceiling(0.234, 0.01) equals 0.24 Floor(2.5, 1) equals 2 Floor(2.5) equals 2 Floor(-2.5, -2) equals -2 Floor(-2.5, 2

tek-tips.com