RoundUp help!

[fodman]

Hello,

if A2-A1 is displayed in A3. How do i use the RoundUp function in A3 without creating a circular reference?

I hope that makes sense, any help much appreciated.
Thanks.

[davesexcel]

=roundup(a1+b1,0)

[Karen]

Hi Fodman,

I would likely try =ROUNDUP(A1-A2,0)

without adding anything extra. (You could change the specifics of the
roundup function to whichever amount of rounding you wanted).

Best of luck with this!
Karen

[Karen]

Oops! Didn't see that Dave had already answered your question!

K

[fodman]

Works perfectly, thanks!

[davesexcel]

quite alright I had the wrong formula anyway
Dave