Hi
Mental block. Using Excel to cost out a project. One example, weed contrail fabric. Spreadsheet works out that I need 1.25 rolls at £7.99, so cost is £9.99 (rounded up).
In reality I'd have to buy 2 rolls, so cost would be £15.98.
I can format the cell to 'no decimal places', which in this case shows 1 roll & still £9.99.
How do I get Excel to work in whole numbers, rounded up?