+ Reply to Thread
Results 1 to 2 of 2

Formula that makes a calculation based on a MAX value between two predefined fixed numbers

  1. #1
    Registered User
    Join Date
    04-05-2023
    Location
    France
    MS-Off Ver
    2010
    Posts
    4

    Arrow Formula that makes a calculation based on a MAX value between two predefined fixed numbers

    Hello,
    I need to create a macro or just a formula. I am not sure if a simple formula may be used instead of a macro. I don't have much experience with macros. If possible, please provide the whole code.

    In a cell A1, there is a value of 30000.

    I need a formula or a macro that will allow to look up if the amount exceeds a predefined fixed amount of 10 000 in a cell and if so, takes a MAX value within a specific predefined range between two numbers 10 000 - 20 000. Then, deducts 10 000 (a fixed number) from a MAX value within that range. Then applies a fixed percentage of 11% on that amount and provides the result in the cell.

    Example 1. Cell A1 has the amount is 30000. Then the calculation should be : (20000 - 10000) x 0.11= 1100
    Example 2. Cell A2 contains the amount of 18000. Then the calculation should be : (20000-18000) x 0.11 = 220 In this case, 18000 is a Max value within a predefined specified range 10000 and 20000

    Thank you in advance for your help

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Formula that makes a calculation based on a MAX value between two predefined fixed num

    The logic behind these 2 examples is not clear for me, so try answering:

    What if A3 contains 40000
    and what if A4 contains 9000?
    Best Regards,

    Kaper

+ 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. Replies: 4
    Last Post: 04-08-2023, 12:55 PM
  2. [SOLVED] Time calculation based on fixed rate
    By Khaldon in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-03-2021, 05:28 PM
  3. Replies: 9
    Last Post: 11-05-2014, 08:17 AM
  4. Text to Columns Fixed Width Using Predefined Lengths
    By easycompany16 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-15-2012, 02:45 PM
  5. Replies: 2
    Last Post: 11-22-2011, 12:33 PM
  6. Get inputs to calculation based on column numbers if exist, if not use fixed value
    By amandaca in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2011, 11:30 AM
  7. Text to columns macro (fixed width) w/ predefined format on result
    By dusit_t in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2009, 11:21 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