Excel Functions in Access?

In a recent forum posting, APRILMASTERS asks:

Is there any way to use the Excel formulas, SLOPE, INTERCEPT and CORREL in an Access form? They work fine in the Excel spreadsheet we have, and the commands show up in the MS Access help and claim these commands can be used in VBA (just doesn't mention how they can be used).

My Excel formulas look like this:

=IF(B8>0,CORREL($B$8:$B$10,C8:C10))

=IF(B8>0,SLOPE(B8:B10,$A$8:$A$10))

=IF(B8>0,INTERCEPT(B8:B10,$A$8:$A$10))

Could these be translated to access referring to Access fields instead of Excel cells?

Can you help? Join us in the forum!