How to =trend

[Charles Mckey]

when i plug in absorbance value in c26 the value won't populate c28 which has =iferror(trend(c2-c4,b2-b4,c26),"")

[#2]

Hi Charles

Just looking at your formula, did you mean to do a range that includes C2, C3, C4 or did you literally mean C2 minus C4?

=IFERROR(TREND(C2:C4,B2:B4,C26),"")

Making the value a range got the formula to work for me?

Cheers
Damien