after calculating, round a cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can a formula be used with a roundup function in the same cell? For example,
calculate a dollar (w/ cents) amount, then round to the nearest dollar.
 
Yes, the fun part of this. If your original formula is
=A1*2/3
then wrap the second formula around it like this:
=ROUNDUP(A1*2/3,0)

HTH. Best wishes Harald
 
That was the answer I was looking for. I knew there must be a way to
incorporate the function. I kept getting a circular logic message.
Thanks Harald.

C
 
Back
Top