Okay take row 8 for example Lime Swirly Negg,
The formula for that is =SUM(B8/C8) how would I implement ROUNDDOWN correctly here?
=ROUNDDOWN(SUM(B24/C24),-2) will give you 2,500.
=ROUNDDOWN(SUM(B24/C24),0) will give you 2,533.
edit: If you only want to get rid of the decimals, you can format the entire colum to rounded (Format > Number > 1,000 Rounded).
Edited by mintpro, 29 October 2013 - 12:41 AM.