Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Rounding with different dollar values



1 comment

  • Liz Walters

    Hi Liz (what a great name 😉),

    Thank you for your question! I'm thinking that a type of linking that we call "chain linking" could be helpful here. To chain link, you'll reference your desired source in another cell (sometimes users will create a new column for this, image below). Next, you'll round the value in the new cell to display in thousands. You'll then link the rounded cell to your destinations. 

    Hope this helps! If you still experience issues, please let us know. Charts can have settings that affect rounding, too. If the charts continue to display incorrectly, a screenshot or further description may help us provide some more suggestions. 

    Thank you!


Please sign in to leave a comment.