Results 1 to 4 of 4

Divide by number of years in dropdown list otherwise 0

Threaded View

  1. 09-29-2023, 11:06 AM #1
    Farhasnat
    Farhasnat is offline
    Registered User
    Join Date
    12-14-2021
    Location
    Bangkok
    MS-Off Ver
    MS Office 365, Verision 16.55
    Posts
    62

    Divide by number of years in dropdown list otherwise 0

    I want to have a formula in cell N7 where the number will be divided by the years selected in the dropdown list and otherwise 0 for other years
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Proper Function to add a number from a helper dropdown list if a certain dropdown is used
    By rgoins82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-30-2021, 01:17 PM
  2. How to get list of months for specific number of years?
    By milindbharambe in forum Excel General
    Replies: 4
    Last Post: 04-16-2014, 08:03 AM
  3. How to divide a cost over a number of years at different frequencies?
    By Jenny27 in forum Excel General
    Replies: 2
    Last Post: 05-31-2013, 12:52 PM
  4. how to count dates and divide in years
    By DMR1712 in forum Excel General
    Replies: 3
    Last Post: 07-16-2010, 02:46 AM
  5. HELP?! Divide a sum by number if items in list
    By jonnykanzen in forum Excel General
    Replies: 3
    Last Post: 10-02-2008, 05:21 AM
  6. [SOLVED] how do I subtract years and then divide
    By crystal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-22-2005, 03:05 PM
  7. [SOLVED] Excel formula divide list of #s by N to get a number above 40
    By JudyK in forum Excel General
    Replies: 11
    Last Post: 02-09-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1