I have a list of data that needs to be used in a lognormdist function. I have arranged a table with a formula in cell B20: Average(ln(B2),ln(B3),ln(B4),ln(B5)....etc) and one in B21: stdev(ln(B2),ln(B3),ln(B4),ln(B5)....etc). I have it arranged like this so a table on another sheet will update as the data in the table is changed. The problem I am having is I want to delete the lowest and highest amounts from each row of data, but deleting the data makes the LN function give an error since the natural log of 0 is undefined. Is there a way to ignore this error and only include the cells with data in them into the formula without havig to exclude the cells I want to delete? I have attached an example document. In the document say I want to delete the entire first row or delete individual data from different cells within the table, how do you make the formula give an answer by only using the undeleted data and ignoring the LN error? You will notice there is a normdist formula in the file as well, there is no error with this function just the lognormdist one. Sorry if there's any confusion let me know if I need to make it more clear.
Bookmarks