Excel help

[flyer]

I'm trying to create a spread sheet that will automatically produce a list of parts given basic information from sales staff. This involves producing a list of panels to construct a wall to fit within a given space. The wall is produced by panels that come in 300mm increments, so you can have 300mm, 600mm 900mm and 1200mm. You cannot have 950mm or 675mm for example.

So I want the staff member to put the true measured value in cell A1 and then I want the spread sheet to put the effective size in cell A2.

For example true measure is 933mm, spread sheet converts this in cell A2 to 900mm. True measure is 599mm spread sheet converts to 300mm. Note, it's very important that the spread sheet always rounds down and never up. If it did, then a true measure of 500mm would result in an answer of 600mm which wouldn't fit.

You've helped me out before, any chance you could do it again

Thanks

 

[quiet_riot]

The round function will do this. =ROUND(X,Y)
X is the number (cell reference) you want rounding
Y is the number of decimal places you want it to round to. If you want something rounded to 3 decimal places, Y would be 3. Y can take negative values, such as -1, which rounds to the nearest ten and -2, which rounds to the nearest hundred, which you are after.
Assuming the cell you want rounding is F10, the equation is =ROUND(F10,-2)

 

[bluesmith]

The round function will do this. =ROUND(X,Y)
X is the number (cell reference) you want rounding
Y is the number of decimal places you want it to round to. If you want something rounded to 3 decimal places, Y would be 3. Y can take negative values, such as -1, which rounds to the nearest ten and -2, which rounds to the nearest hundred, which you are after.
Assuming the cell you want rounding is F10, the equation is =ROUND(F10,-2)

Close, but he would have to use the Round Down Forumla =ROUNDDOWN(A1,-2), but that would only do it in 100 increments not 300.

Edit - =FLOOR(A1,300) should do it.

 

[flyer]

I'll give this a whirl in the morning, thanks again

 

[TonyM]

I would have done... =ROUNDDOWN(A1/300,0)*300

But floor is cleaner and a new command for me. :-) thanks!

 

[flyer]

Thanks for the help. Bluesmith's solution does the job