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.


--
fodman
------------------------------------------------------------------------
fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941
View this thread: http://www.excelforum.com/showthread...hreadid=516651

=roundup(a1+b1,0)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516651

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

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

K

Works perfectly, thanks! :)


--
fodman
------------------------------------------------------------------------
fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941
View this thread: http://www.excelforum.com/showthread...hreadid=516651

quite alright I had the wrong formula anyway
Dave


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516651