Forum Discussion
Tlang2010
Mar 29, 2019Copper Contributor
Help with simple IF THEN formula
Balance carried forward from 2018 21.00 MONTH HOURS EARNED HOURS USED HOURS USED HOURS USED HOURS USED BALANCE January 1.75 0.00 ...
Twifoo
Mar 29, 2019Silver Contributor
Specifically, the formula in G7 is:
=MIN(21,
SUM(G5,B7)-SUM(C7:F7))
=MIN(21,
SUM(G5,B7)-SUM(C7:F7))