Results 1 to 10 of 10

Two figures in financial model should match, but don't

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2013
    Location
    USA
    MS-Off Ver
    16.63.1 (2022)
    Posts
    82

    Two figures in financial model should match, but don't

    We have built a very detailed RE Development financial model and in our returns section, we can seem to the sum of the different variable by asset type to equal the total of the parts of the same variable. It is driving us mad! We're off by 0.40 and 0.70. We have used the ROUND function to see if that would allow us to get the value to equal each other. But no luck. ANY HELP, PLEASE.
    We are using INDEX(MATCH ...) to get the values based on the terminal date.

    The model is too big to load here so I need some direction on how to get you the example.
    Last edited by 6StringJazzer; 04-29-2021 at 09:12 PM. Reason: better titles please

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 02-03-2014, 08:05 AM
  2. Time Calculations(Cont...)
    By ExceltoLead in forum Excel General
    Replies: 4
    Last Post: 03-21-2011, 06:21 AM
  3. how to cont unique values
    By KORT in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-12-2010, 05:25 PM
  4. Cont.se with several tables
    By douglascaixeta in forum Excel General
    Replies: 3
    Last Post: 05-20-2010, 02:31 AM
  5. [SOLVED] Help cont'd
    By A.S. in forum Excel General
    Replies: 1
    Last Post: 08-04-2006, 02:40 PM
  6. [SOLVED] Macro HELP! Cont
    By Jenny in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2005, 10:05 AM
  7. Cont question
    By Peter in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-01-2005, 06:05 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