+ Reply to Thread
Results 1 to 7 of 7

WTA : How is the formula in column amount with different percentage?

  1. #1
    Registered User
    Join Date
    04-30-2015
    Location
    indonesia
    MS-Off Ver
    2013
    Posts
    9

    WTA : How is the formula in column amount with different percentage?

    Please take a look in my attachment file

    i want to make formula in my AMOUNT column based on IN column. there is a code in every color also, how is the formula?
    yellow is 90% off
    green is 100% off

    i do put the amount how supposed to be done without formula.

    i hope there is someone can help me to solve this. thank you
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,597

    Re: WTA : How is the formula in column amount with different percentage?

    % of what ? Not sure I understand but you can use Conditional Formatting to colour the cells.

  3. #3
    Registered User
    Join Date
    04-30-2015
    Location
    indonesia
    MS-Off Ver
    2013
    Posts
    9

    Re: WTA : How is the formula in column amount with different percentage?

    im sorry but forget about the colour there.

    what i want is if i
    input 50.000 in C4 column, is appear 45 in B4 column (50.000*90%/1000=45) abc 123
    input 20.000 in C8 column, is appear 18 in B8 column (20.000*90%/1000=18) abc 234
    input 50.000 in C9 column, is appear 50 in C9 column (50.000*100%/1000=50) qwe 456

    abc = 90%
    qwe = 100%

    i hope you get what i mean. i was confuse how to make the formula in amount column B.

  4. #4
    Registered User
    Join Date
    04-30-2015
    Location
    indonesia
    MS-Off Ver
    2013
    Posts
    9

    Re: WTA : How is the formula in column amount with different percentage?

    im sorry but forget about the colour there.

    what i want is if i
    input 50.000 in C4 column, is appear 45 in B4 column (50.000*90%/1000=45) abc 123
    input 20.000 in C8 column, is appear 18 in B8 column (20.000*90%/1000=18) abc 234
    input 50.000 in C9 column, is appear 50 in C9 column (50.000*100%/1000=50) qwe 456

    abc = 90%
    qwe = 100%

    i hope you get what i mean. i was confuse how to make the formula in amount column B.

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,597

    Re: WTA : How is the formula in column amount with different percentage?

    Still not sure ,,

    in B4

    =$C4*0.9/1000

    will give 90%

  6. #6
    Registered User
    Join Date
    04-30-2015
    Location
    indonesia
    MS-Off Ver
    2013
    Posts
    9

    Re: WTA : How is the formula in column amount with different percentage?

    what you said its true but if I drag down the formula all that column will give 90%, how about the qwe code? it should be 100%.

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,814

    Re: WTA : How is the formula in column amount with different percentage?

    Please try the following in cell B4 and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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 subtract percentage and dollar amount
    By Fredbugatti in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-10-2018, 02:32 PM
  2. Formula to change percentage charged depending on transaction amount
    By ManuelP in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-24-2017, 06:07 AM
  3. [SOLVED] Need formula to subtract a dollar amount or percentage
    By Nate.christoffels in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-29-2016, 12:34 AM
  4. Formula to give me an amount from a percentage
    By Medici88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2015, 09:18 AM
  5. [SOLVED] Calculate number/percentage less than x amount based on text in another column
    By dvs in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2013, 10:10 AM
  6. [SOLVED] Formula to Show Percentage Amount
    By FrumpyJones in forum Excel General
    Replies: 2
    Last Post: 04-02-2012, 01:38 PM
  7. Return a percentage of amount of values in column
    By mcwee72 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2010, 07:51 AM

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