Intercept Formula, which excludes #N/A cells

[Pedro's PhD]

Hi,

Just a quick question regarding the function =INTERCEPT

I'm using the formula =INTERCEPT(B5:DQ5,B6:DQ6) which works fine, until one of the cells in the range becomes a #N/A.

Is there any way I can adapt the formula to ignore such a cell?

Thanks in advance,

Pedro

 

[Aladin Akyurek]

Hi,

Just a quick question regarding the function =INTERCEPT

I'm using the formula =INTERCEPT(B5:DQ5,B6:DQ6) which works fine, until one of the cells in the range becomes a #N/A.

Is there any way I can adapt the formula to ignore such a cell?

Thanks in advance,

Pedro

Control+shift+enter, not just enter:

=INTERCEPT(IF(ISNUMBER(B5:DQ5),B5:DQ5),IF(ISNUMBER(B6:DQ6),B6:DQ6))

 

[Pedro's PhD]

Perfect!

Many thanks.... Pedro

 

[Aladin Akyurek]

Perfect!

Many thanks.... Pedro

You are welcome. Thanks for providing feedback.