Results 1 to 5 of 5

INT Formula Not Working Correctly

Threaded View

chrisbay2324 INT Formula Not Working... 08-20-2018, 09:38 AM
63falcondude Re: INT Formula Not Working... 08-20-2018, 09:42 AM
davsth Re: INT Formula Not Working... 08-20-2018, 09:45 AM
chrisbay2324 Re: INT Formula Not Working... 08-20-2018, 09:57 AM
63falcondude Re: INT Formula Not Working... 08-20-2018, 09:59 AM
  1. #1
    Registered User
    Join Date
    08-20-2018
    Location
    Austin, Texas
    MS-Off Ver
    Window 10
    Posts
    3

    INT Formula Not Working Correctly

    New User,

    1. I am creating a Dashboard with average weeks and days. I am using this formula to calculate the average amount days. For Example, 145 days is shown in cell G9 as a result of the formula below:

    =IFERROR(AVERAGEIFS(Curt_T[DURATION(DAYS)],Curt_T[STAGE],"Adopted Technology",Curt_T[CLOSED],"CLOSED"),"")

    The I am using this formula to calculate amount of Weeks and Days left over.

    =INT((G9)/7)&" weeks"&IF(MOD(G9,7)=0,"",", "&MOD(G9,7)&" days")

    The formula is producing 20 weeks and 4.666666666666666 days. I need my formula to round down to 4 days. I am in Sales and I love excel but I am working with limited knowledge. This is my first time posting to a forum like this.

    Thanks in advance,

    CB
    Last edited by chrisbay2324; 08-20-2018 at 09:41 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Why is this If Function not working correctly
    By trying-my-best in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-17-2017, 12:48 PM
  2. IF function not returning expected result
    By kapeller in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-21-2014, 10:12 AM
  3. [SOLVED] Using the Split function with another function incorporated is not working correctly
    By highlystrung in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2013, 03:51 PM
  4. If function not working correctly
    By lsbeuk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2011, 09:26 PM
  5. Excel 2007 : Count If function not working correctly
    By sir yes sir in forum Excel General
    Replies: 4
    Last Post: 02-10-2011, 04:23 AM
  6. [SOLVED] Lookup function still not working correctly
    By Mike K in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. Lookup function still not working correctly
    By Mike K in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11: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