+ Reply to Thread
Results 1 to 3 of 3

Need help figuring out a formula

  1. #1
    Registered User
    Join Date
    06-15-2015
    Location
    WV
    MS-Off Ver
    2013
    Posts
    17

    Need help figuring out a formula

    I want the code for actual mtd to reflect after a certain date I want the reminder of the chart to show 0s. for example if I only want up to June 20th I want every date afterwards to reflect a 0. When I drag down the formula for actual mtd and goal mtd if a 0 is present I don't want it to restart my count.


    Please Login or Register  to view this content.

    Sand Tracking SharePoint - Q2 2015.xlsx
    Last edited by tejasjeorge; 06-30-2015 at 10:12 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    502

    Re: Need help figuring out a formula

    Forum Sand Tracking SharePoint - Q2 2015.xlsx

    Is this what you mean

    Yellow highlites the changes

  3. #3
    Registered User
    Join Date
    06-15-2015
    Location
    WV
    MS-Off Ver
    2013
    Posts
    17

    Re: Need help figuring out a formula

    When you input numbers in the count of tonnage column the actual mtd column does not update and change at all.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do you calculate Square Foot in a formula
    By icevinson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2014, 02:58 AM
  2. Need help figuring out a formula
    By Corporate Bob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2013, 03:03 AM
  3. Figuring out the appropriate formula with IFS
    By Vallheos in forum Excel General
    Replies: 4
    Last Post: 09-02-2011, 01:31 AM
  4. Need help with figuring out a formula please
    By DavidJ726 in forum Excel General
    Replies: 5
    Last Post: 05-29-2006, 11:25 PM
  5. [SOLVED] Figuring Out A formula to...
    By ken in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-06-2005, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1