A
April Legate
I've got a MS Excel spreadsheet I'm trying to convert into
MS Access. It works great except for three fields that use
the CORREL, SLOPE and INTERCEPT worksheet functions. I
need these fields, but I'm not sure how to convert them.
Everything I've tried so far hasn't worked.
Any ideas?
The formulas are:
=IF(B8>0,CORREL($B$8:$B$10,A8:A10))
=IF(B8>0,SLOPE(B8:B10,$A$8:$A$10))
=IF(B8>0,INTERCEPT(B8:B10,$A$8:$A$10))
Thanks!
April
MS Access. It works great except for three fields that use
the CORREL, SLOPE and INTERCEPT worksheet functions. I
need these fields, but I'm not sure how to convert them.
Everything I've tried so far hasn't worked.
Any ideas?
The formulas are:
=IF(B8>0,CORREL($B$8:$B$10,A8:A10))
=IF(B8>0,SLOPE(B8:B10,$A$8:$A$10))
=IF(B8>0,INTERCEPT(B8:B10,$A$8:$A$10))
Thanks!
April