excel help

  starlet 09:03 11 Oct 08
Locked

Hi trying to add roundup to a simple column of currency but returns error, setting it up into a new column works okay but shows hash value until the figures are added.

In column L8 =IF(C8=0,"",J8*C8)
In column M8 =ROUNDUP(L8:L32,0)

I would like to have total including roundup in one column please if someone can show me how to do it

Starlet

  VoG II 09:19 11 Oct 08

Perhaps

=ROUNDUP(SUM(L8:L32),0)

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…