+ Reply to Thread
Results 1 to 5 of 5

Adding Rounding to the Hundreths to index formula

  1. #1
    Registered User
    Join Date
    01-26-2016
    Location
    TX
    MS-Off Ver
    Excel 2013
    Posts
    74

    Adding Rounding to the Hundreths to index formula

    I have this formula that works to give me the result I want; however, I would need the index result, if applicable rounded to the hundredths. How can I incorporate that in here?


    =IF($D4="","",IF($L4="BOP",(INDEX('Phase 1'!$1:$1048576,MATCH($C4,'Phase 1'!A:A,0),11)),""))


    Thanks in advance!
    Rookie

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,136

    Re: Adding Rounding to the Hundreths to index formula

    hi there. try:
    =IF($D4="","",IF($L4="BOP",ROUND(INDEX('Phase 1'!$1:$1048576,MATCH($C4,'Phase 1'!A:A,0),11),-2),""))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,159

    Re: Adding Rounding to the Hundreths to index formula

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  4. #4
    Registered User
    Join Date
    01-26-2016
    Location
    TX
    MS-Off Ver
    Excel 2013
    Posts
    74

    Re: Adding Rounding to the Hundreths to index formula

    Thank you both!

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,159

    Re: Adding Rounding to the Hundreths to index formula

    You are welcome. Thank you for the feedback and marking this thread Solved.

+ 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. Adding a function to an INDEX formula
    By dubseven in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-05-2017, 12:03 PM
  2. [SOLVED] Adding IFs to Index Match formula
    By jarheadmartian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-30-2016, 03:21 PM
  3. Help adding criteria to INDEX formula
    By marciofo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2016, 04:44 AM
  4. Adding an If statement to an Index Match Formula
    By brandiemz101 in forum Excel General
    Replies: 3
    Last Post: 11-16-2011, 03:25 PM
  5. Replies: 2
    Last Post: 07-30-2010, 10:02 PM
  6. Hundreths
    By ww2u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2006, 01:57 AM

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