+ Reply to Thread
Results 1 to 4 of 4

Trying to return a formula based on a text column with variables (5)

  1. #1
    Registered User
    Join Date
    06-10-2024
    Location
    Washington, US
    MS-Off Ver
    16.8.5
    Posts
    2

    Post Trying to return a formula based on a text column with variables (5)

    I have a spreadsheet that lists what payment terms have been agreed to (monthly, quarterly, biannual, annual, custom) and I want a column that takes the total of another column and then finds the payment terms and divides the number according to how many payments.

    For example
    Client A is paying quarterly, 5000, result should be 1250
    Client B is paying annually, 5000, result 5000
    Client C is paying monthly, 5000, result 416.67
    Client D is paying biannually, 5000, result 2500

    How do I get it to look at the text column (Col X) and then look at the number column (L) and return the right split?

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.97.2 for Mac MS 365
    Posts
    8,708

    Re: Trying to return a formula based on a text column with variables (5)

    try this... =IF(X2="annually",L2,IF(X2="biannually",L2/2,IF(X2="quarterly",L2/4,IF(X2="monthly",L2/12,""))))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    06-10-2024
    Location
    Washington, US
    MS-Off Ver
    16.8.5
    Posts
    2

    Exclamation Re: Trying to return a formula based on a text column with variables (5)

    YOU ARE A MAGICAL UNICORN. Thank you!

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.97.2 for Mac MS 365
    Posts
    8,708

    Re: Trying to return a formula based on a text column with variables (5)

    Thank you, glad I could help, AND thank YOU for the rep!

+ 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 to return value based on multiple variables (including date)
    By bandbl64 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2023, 03:12 PM
  2. Replies: 1
    Last Post: 05-08-2021, 11:09 PM
  3. Formula to combine text based on variables
    By billyshears in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-08-2016, 04:28 PM
  4. Return a value based on 2 variables in one column.
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-05-2015, 09:48 PM
  5. Code To Look In Multiple Sheets Return Value Based On Row and Column Variables
    By ZooTV92 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2015, 01:19 PM
  6. Formula to Return a Value based on 2 Variables
    By Howdoesitwork in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-30-2015, 12:42 PM
  7. [SOLVED] Return the lowest value in one column based on a text search in a different column.
    By Juliana33 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-11-2012, 09:58 AM

Tags for this Thread

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