RoundUp help!
 

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 help!
 

=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

RoundUp help!
 

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

RoundUp help!
 

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

K

RoundUp help!
 

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

RoundUp help!
 

:cool:
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