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!