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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:01 AM.