the short answer is no. The ways to do it are
1. add a column to excel with the calculated value
2. link to excel the use a query (using val) to import from the linked table
3. use transferspreadsheet to import the worksheet to a temporary table then use a query (usng val) to append to your table