excel help

  starlet 09:03 11 Oct 2008
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 2008

Perhaps

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

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

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?