Hi,

i'd like to set several cells to automatically round up to the next whole number when any number has a decimal.

The trouble is these cells are effectively "Total" Cells and already have the following formula in them to generate a value;

=SUM(F5/E6)

can i set this cell with this formula to round up to the next whole number