+ Reply to Thread
Results 1 to 4 of 4

Cell Formula based on drop-down result in other cell

  1. #1
    Registered User
    Join Date
    08-13-2017
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    2

    Cell Formula based on drop-down result in other cell

    I am creating a Monthly budgeting spreadsheet and wish to know if there is an easy way that the values in column D are able to be calculated back to a monthly value based on the frequency value paid chosen from the drop down list in column C?

    Untitled.png

    Thanks.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Cell Formula based on drop-down result in other cell

    maybe this one in D2 and drag down

    =CHOOSE(MATCH(C2,{"Daily","Weekly","Fortnightly","Monthly","Annualy","Adhoc"},0),B2*365/12,B2*52/12,B2*26/12,B2,B2/12,B2)

    if I understood well
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    08-13-2017
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    2

    Re: Cell Formula based on drop-down result in other cell

    Perfect! Thanks Sandy

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Cell Formula based on drop-down result in other cell

    You are welcome

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)

    If you did it already - ignore it.
    Thank you.

+ 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. [SOLVED] Formula that will result the cell blank based on adjacent cell
    By LShepherd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-20-2016, 01:04 PM
  2. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  3. Help: How do I have a drop-down cell auto-populate other cells based on result?
    By benjamin.glover in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2014, 01:46 PM
  4. [SOLVED] Conditional format a cell based on a result of a formula in another cell
    By Taiter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-20-2013, 04:45 PM
  5. [SOLVED] Conditional format a cell based on a result of a formula in another cell
    By Taiter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-20-2013, 01:47 PM
  6. [SOLVED] Formula to fill a cell based on drop down list in previous cell
    By formatting freak in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-03-2013, 01:18 AM
  7. Cell result is based on the drop down selected
    By payroll_lady in forum Excel General
    Replies: 0
    Last Post: 01-08-2013, 06:00 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