=IF(B38 = 0, 0,C37+B38) =D37+$F$5Please Login or Register to view this content.
Need help fine turning this code so that when I enter a 0 it doesn't restart my actual and goal MTD count.
Sand Tracking SharePoint - Q2 2015.xlsx
=IF(B38 = 0, 0,C37+B38) =D37+$F$5Please Login or Register to view this content.
Need help fine turning this code so that when I enter a 0 it doesn't restart my actual and goal MTD count.
Sand Tracking SharePoint - Q2 2015.xlsx
Last edited by tejasjeorge; 06-30-2015 at 10:12 AM.
Your workbook is protected so it is impossible to add rows matching TODAY() to test the formula. Could you attach an unprotected copy please?
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks