matlab function not recognised by excel
Ältere Kommentare anzeigen
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 Kommentare
dpb
am 17 Jun. 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
am 18 Jun. 2019
Bearbeitet: Gavin Seddon
am 18 Jun. 2019
Gavin Seddon
am 19 Jun. 2019
Bearbeitet: Gavin Seddon
am 19 Jun. 2019
Antworten (0)
Kategorien
Mehr zu Data Export to MATLAB finden Sie in Hilfe-Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!