matlab function not recognised by excel
Show older comments
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
dpb
on 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
on 18 Jun 2019
Edited: Gavin Seddon
on 18 Jun 2019
Gavin Seddon
on 19 Jun 2019
Edited: Gavin Seddon
on 19 Jun 2019
Answers (0)
Categories
Find more on Data Export to MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!