1 | =REDUCE(初始血量格,戰鬥記錄表格範圍, LAMBDA(total, change, IF(isnumber(change),IF(IFERROR(total+change,total)>初始血量格,初始血量格,total+change),total+0))) |
Direct link: https://paste.plurk.com/show/3SQbhrYTXGj9kqUVOZCE
1 | =REDUCE(初始血量格,戰鬥記錄表格範圍, LAMBDA(total, change, IF(isnumber(change),IF(IFERROR(total+change,total)>初始血量格,初始血量格,total+change),total+0))) |