Eat whole foods: Whole foods are foods that havenât been tampered with, in the lab or the manufacturing plant. The foods you eat on this plan are straight from the farm: whole fruits and vegetables, whole grains, grass-fed and free-range meats, low fat dairy products, unsalted nuts, and seeds.
You need to replace its results with values. Just follow the simple steps below: 1  Select all the cells with formulas that you want to convert. 2  Press Ctrl + C or Ctrl + Ins to copy formulas and their results to clipboard.  3. Press Shift+F10 and then V to paste only values back to Excel cells.
For example, if you try to use the formula =OFFSET(A1,3,1,1,3) on its own, it will throw a #VALUE! error, since a range to return (1 row, 3 columns) does not fit into a single cell. However, if you embed it into the SUM function, like this: =SUM(OFFSET(A1,3,1,1,3)) The formula will return the sum of values in a 1-row by 3-column range that is 3 rows below and 1 column to the right of cell A1, i.e. the total of values in cells B4:D4.