Thread: [Solved] Formula to delete but maintain counts after the maximum has been reached
View Single Post
 
Old 01-03-2018, 01:38 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
In D2, try:

=IF(C2<=12,"",-(MIN(B2,C2-12)))

or

=-MAX(0,(MIN(B2,C2-12))) with custom format 0;[Red](0);;@

 If you choose first formula, then in order not to get #VALUE! error in column E, change formula in E2 to:

=SUM(D2,B2)

both copied down
Reply With Quote