how can i get the slope function to ignore missing data?
I have a spreadsheet that needs to calculate the slope of a line. The x
values are in column a, the y values in column d. The slope function in excel 2003 works just fine for this purpose until it encounters missing data. The slope function returns #N/A. I have tried entering #N/A for the missing data but the result is the same. How can I get it to simply ignore my missing data? |
All times are GMT +1. The time now is 03:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com