Help with formula

[fernipascual]

Ok. I am trying to assign values in increments of 6,000 after I average my customers purchases. For example, 96,000 divided by 32 and multiplied by 1.5 = 4,500.

In the example above I am not getting multiples of 6,000. What would be the formula to round this up to the next increment of 6,000? If the average were 8,000 it would need to round up to 12,000.

Thanks for the help!

 

[VoG]

Try

=CEILING(A5/32*1.5,6000)

 

[Mike Blackman]

Hi,

Something like this maybe?

=ROUNDUP(A1/6000,0)*6000

 

[lenze]

Ceiling(A1,6000)

lenze

 

[fernipascual]

Great, thanks much, CEILING worked. Can you explain what CEILING does?

 

[VoG]

It rounds up to the nearest multiple.