matlab function not recognised by excel

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 Comments

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 on 18 Jun 2019
Edited: Gavin Seddon on 18 Jun 2019
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 on 19 Jun 2019
Edited: Gavin Seddon on 19 Jun 2019
hello, do you think simulink may help? Bearing in mind I use mac
gs

Sign in to comment.

Answers (0)

Categories

Asked:

on 17 Jun 2019

Edited:

on 19 Jun 2019

Community Treasure Hunt

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

Start Hunting!