+ Reply to Thread
Results 1 to 3 of 3

[SOLVED] DSO or Creating Named Formula

  1. #1
    Registered User
    Join Date
    01-27-2023
    Location
    London
    MS-Off Ver
    2021
    Posts
    3

    [SOLVED] DSO or Creating Named Formula

    Hi,

    I have the nagging feeling that this is a really obvious question, but here goes!

    So, at work, I've been looking at some calculations to do with days sales outstanding and came across a spreadsheet put together by a colleague who has since left. For the most part it makes sense, but the calculation that relates to days sales outstanding (DSO) is confusing me somewhat. In the Excel sheet, there's an actual formula called DSO that does this calculation and I've uploaded a dumbed down version of what I'm looking at.

    Wanting to know more, I've looked online for an Excel formula named DSO, but have come up short. I then checked Excel on my personal computer and found that no such formula exists in that instance. This makes me believe that somehow a named formula, as well as box for function arguments, has been created by this ex-colleague. If true, I've not seen this done before in Excel.

    If I'm right can someone point me in the direction of where I might read up more on this. However, if DSO is a formula within Excel, can someone say why that doesn't appear in available formula or where guidance for it online might be?

    Thanks a lot!
    Attached Images Attached Images
    Last edited by sandwhale; 01-28-2023 at 06:00 AM.

  2. #2
    Registered User
    Join Date
    01-27-2023
    Location
    London
    MS-Off Ver
    2021
    Posts
    3

    Re: DSO or Creating Named Formula

    Just realised that this is a user defined function, but would anyone have an idea about how I navigate to where this function is saved?
    I don't want to have to trawl through lots of formulas I barely understand if I can help it

  3. #3
    Registered User
    Join Date
    01-27-2023
    Location
    London
    MS-Off Ver
    2021
    Posts
    3

    Re: DSO or Creating Named Formula

    Happily, after much digging, I've found where the stupid formula is hiding. No more question on my side.

+ 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. Use formula on "Refers to" when creating a named range
    By NickNunes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2019, 05:16 AM
  2. [SOLVED] Creating a Named Field with a formula in that cell
    By Excel987 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2019, 08:00 PM
  3. Assistance required with creating a formula for a named range of figures
    By magabicool in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2016, 11:47 AM
  4. Replies: 0
    Last Post: 03-08-2016, 02:25 PM
  5. Formula doesn't work when named and/or Using COLUMN() in a named formula
    By anne1991 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2015, 10:47 PM
  6. [SOLVED] Creating Named Ranges with VBA
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2006, 01:05 PM
  7. Creating a named range
    By Gixxer_J_97 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2005, 06:10 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