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 commentaires

dpb
dpb le 17 Juin 2019
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 le 18 Juin 2019
Modifié(e) : Gavin Seddon le 18 Juin 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 le 19 Juin 2019
Modifié(e) : Gavin Seddon le 19 Juin 2019
hello, do you think simulink may help? Bearing in mind I use mac
gs

Connectez-vous pour commenter.

Réponses (0)

Catégories

Community Treasure Hunt

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

Start Hunting!

Translated by