Use IFERROR to deal with likely glitches in your formulas gracefully. It allows you to specify a worth or action to consider In the event the formula brings about an mistake, bettering the user experience of your respective spreadsheet. Use CORREL to work out the correlation coefficient concerning two datasets. https://hc6.org/