Can someone advise an easy way to round offers and increase offers by percentage in Excel or Sheets after I have pulled the data? For example, instead of sending offers such as $8,801, I would rather send offers for $8,800. Or I may want to increase my offers for 5 acres and up 10%. I am trying to round and/or increase several offers in the pricing column at the same time, not one cell at a time. One way I found was to add columns, use MROUND, Paste Special, Values Only, etc., but there has to be an easier way. Any help is much appreciated.
top of page
bottom of page
Ben - Your rounding question stumps me, but I do know that in Excel you can create a "IF,THEN" formula to accomplish your selective percentage increase challenge. I've done it myself, but it is one of those things I have to sit and study for awhile each time I need it again. There is likely someone more expert in Excel than I that can jump in and give you better direction, or you can probably find a YouTube video with the information. All the best - gr