SLOPE with the occasional n/a value?

[Berrett]

I need to return the slope of a line, but there are occasional missing values, which, given the formulas that I'm using, return as "#N/A". This is necessary so that my charts will work properly.

However, my SLOPE formula stops working as soon as it encounters an n/a value anywhere in the referenced data.

Anyway to get around this?

 

[schielrn]

I haven't ever used the slope formula and wouldn't know if the expected results I got were right or not, but maybe try something like:

=SLOPE(IF(ISNA(A2:E2),"",A2:E2),IF(ISNA(A1:E1),"",A1:E1))

This needs to be confirmed with control+shift+enter and not just enter.

If this doesn't work, post back with some sample data and expected results.

Hope thta helps.

 

[Aladin Akyurek]

I need to return the slope of a line, but there are occasional missing values, which, given the formulas that I'm using, return as "#N/A". This is necessary so that my charts will work properly.

However, my SLOPE formula stops working as soon as it encounters an n/a value anywhere in the referenced data.

Anyway to get around this?

Example...

Control+shift+enter, not just enter:

=SLOPE(IF(ISNUMBER(B2:B7),B2:B7),IF(ISNUMBER(A2:A7),A2:A7))

 

[Berrett]

Thanks to both of you. I tried Aladin's first and it worked, so I'm sticking with it. But I appreciate both of your help very much.

This place is amazing.