How to add and subtract columns of an imported file while taking a cumulative sum
3 ビュー (過去 30 日間)
古いコメントを表示
Hello,
I'm trying to add one column to a zero column and subtract another column while running a cumulative sum. Additionally, I want any negative value to be set to zero.
Here's what I did in excel: =max(L2+J3-I3,0) So value L3=L2+J3-I3. If that number is negative, then I want the output to be zero. That function carries through the entire column.
I'm pretty lost so any help is greatly appreciated.
0 件のコメント
回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!