Formula to delete but maintain counts after the maximum has been reached

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to delete but maintain counts after the maximum has been reached

FAQ

Thread Tools

Display Modes

01-03-2018, 01:38 PM

NBVC

Windows 10 Formula to delete but maintain counts after the maximum has been reached

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate counts between fluid rows - TIME	rgauss	Excel	3	01-18-2017 04:09 PM
Word 2011 error in character counts	Arbor Friend	Word	0	12-17-2016 12:56 PM
How to maintain formula while using Merge and Centre command	Aditya M	Excel	1	04-11-2016 11:25 PM
Maximum number of working days reached= warning color	perZZon	Excel Programming	1	05-09-2014 03:01 PM
Delete Formula	ibrahimaa	Excel	1	06-24-2011 09:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:12 PM.