convert code from excel to matlab
Show older comments
How do I convert my excel code to matlab? The excel code below contains two "IF" statements and one "AND" statement.
x = IF(AND(2*abs(d)>3*abs(l-n), 2*abs(d)>3*abs(r-n)), 2*abs(d), IF(3*abs(l-n)>3*abs(r-n), 3*abs(l-n), 3*abs(r-n)))
1 Comment
Rena Berman
on 13 Dec 2021
(Answers Dev) Restored edit
Answers (1)
Chunru
on 11 Dec 2021
% x = IF(AND(2*abs(d)>3*abs(l-n), 2*abs(d)>3*abs(r-n)), 2*abs(d), IF(3*abs(l-n)>3*abs(r-n), 3*abs(l-n), 3*abs(r-n)))
if (2*abs(d)>3*abs(l-n)) & (2*abs(d)>3*abs(r-n))
x = 2*abs(d);
elseif (3*abs(l-n)>3*abs(r-n)) & (3*abs(l-n))
x = 3*abs(r-n)));
end
1 Comment
Walter Roberson
on 11 Dec 2021
Note that the above will only work if d and l and n and r are all scalar values. If arrays are being processed then different code would be needed.
Categories
Find more on Spreadsheets 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!