auto fill the next two cells to the cell that a number is added in excel 2016

by irfan erdogan   Last Updated July 12, 2019 04:01 AM

I have 3 columns: (1) Value, (2) yearly percent change and daily percent change. For example; I use the formula =SUM(B18-70)/70 for the yearly change, and =SUM(B12-B11)/B11 for the daily change. The excel does not automatically fill the both cells when I add new value in the first column. (I do not want to copy formulas to the next cells down in each columns because I do not want to see "-100" and "#div/0"). What should I do? Thanks for your help

Related Questions

Updated May 29, 2017 12:01 PM

Updated March 27, 2018 13:01 PM

Updated December 01, 2018 22:01 PM

Updated December 19, 2018 07:01 AM

Updated February 07, 2019 07:01 AM