$$Excel-Macros$$ Average of Columns while excluding certain columns

2016-12-13 Thread Joseph Carney
Hello all , I have a conundrum. I have a table that i am using to collate data from previous years sales. The data is from 2008 thru current year. I have the table set up as follows: *Month | 2008 | 2009 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 5year Average* Unde

$$Excel-Macros$$ Excel Formula using LOG

2016-08-23 Thread Joseph Carney
I understand that this may not pertain to VBA particularly, but I thought that I might ask. I have a spreadsheet that has 4 columns of numbers (simple numbers). A fifth column has the following equation in it: =(11.078+1.131*LOG(B2)+0.416*LOG(C2)-0.274*LOG(D2)-0.005*(E2)) I am having issue