Trend formula ignore Div/0 error

[KMacattack]

i have a couple columns and want to use the Trend Function in excel but that data contains the error #Div/0.

is there an easy way to get around this error.

=TREND($A$1:$A$10,$B$1:$C$10,B1:C1,TRUE)

in column B there is an error div/0


any help is greatly appreciated.

Thank you

 

[Sahak]

Hi KMacattack

I never use this formula but to avoid getting an error div/0 you can use:

 =IF(ISERROR(TREND($A$1:$A$10,$B$1:$C$10,B1:C1,TRUE)=TRUE),0,TREND($A$1:$A$10,$B$1:$C$10,B1:C1,TRUE))