matlab function not recognised by excel

2019 6 17
0 个回答
更新时间：2019 6 19
4 次查看（30 天）

0 个投票

Hello,
I have generated a matlab function and then taken the second derivitive. I want to place this function within an excel spreadsheet column where I change 'x' for 'c' which is the excel column.
I am doing this to create a iterative function.
the function is
- (154886787*sin((381*x)/200 + 319/200))/400000 - (1139910777*sin((1797*x)/1000 - 783/500))/2500000 - (222034827*sin((1229*x)/1000 + 1537/1000))/3125000
the excel error is 'The formula contains unrecognized text.' whilst excel recognises sin can anyone help please?
gs

3 个评论
显示 1更早的评论 隐藏 1更早的评论

dpb
dpb 2019-6-17
The variable would have to be a valid cell inside Excel to be a legal celll formula.
You also can't assign a formula into the value of a cell as a formula; that's a separate method/property of the cell--you could save as text.
Probably bringing Excel into the mix is making for much difficulty--why not just solve the problem entirely in Matlab?
Gavin Seddon
Gavin Seddon 2019-6-18
编辑：Gavin Seddon 2019-6-18
Thank you, is it possible to use the matlab imported values spreadsheet as a spreadsheet?
I have added this formula cell to an existing viable excel document.
gs
Gavin Seddon
Gavin Seddon 2019-6-19
编辑：Gavin Seddon 2019-6-19
hello, do you think simulink may help? Bearing in mind I use mac
gs

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by