matlab function not recognised by excel
Afficher commentaires plus anciens
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
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
le 18 Juin 2019
Modifié(e) : Gavin Seddon
le 18 Juin 2019
Gavin Seddon
le 19 Juin 2019
Modifié(e) : Gavin Seddon
le 19 Juin 2019
Réponses (0)
Catégories
En savoir plus sur Data Export to MATLAB dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!