Forum Discussion
formula: add difference when cell exceeds value to the next cell
Hi all,
I don't know how to solve the following issue. I want to automatically calculate colmn I.
I need to built the followin logic: when a cell exceeds a certain amount (column B), the diff...
Hi Heike,
That could be
=IF($G2<$B2,MIN($B2,$G2+SUM($G$1:$G1)-SUM($I$1:$I1)),$B2)
assuming in first row you have only text, at least in columns G and I.
Please see attached.