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

"C" skrev i melding
...
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.

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

"Harald Staff" wrote:

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

"C" skrev i melding
...
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.

Glad to hear that. Thanks for the feedback.

Best wishes Harald

"C" skrev i melding
...
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.