+ Reply to Thread
Results 1 to 5 of 5

Help me improve my formula

  1. #1
    Registered User
    Join Date
    02-12-2020
    Location
    London
    MS-Off Ver
    MS Office 2019
    Posts
    3

    Question Help me improve my formula

    Hello everyone,

    I need help to improve my formula.

    What it does so far:
    You can enter any TOTAL amount and everything change accordingly (Qty and Total Price)
    To have the right TOTAL I added a formula to the Discount line (in E12 and F12)

    What I want it to do:
    As you can see on my file you will always find that 'Total Prices' are always around the same amounts so I want it to be more uneven (can be random or not)
    For exemple Article 1 Total Price can be 1 300,00 € and Article 2 can be 440 € and so on.

    I hope I'm clear enough, thank you for your help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Help me improve my formula

    for random numbers with greater spread you can use something like
    Please Login or Register  to view this content.
    copy this formula to all cells you need. they will change on any update. If you like the numbers then select a range and copy it and PasteSpecial Values.

  3. #3
    Registered User
    Join Date
    02-12-2020
    Location
    London
    MS-Off Ver
    MS Office 2019
    Posts
    3

    Re: Help me improve my formula

    Thanks for the reply,

    I'm not sure to understand, could you send me the modified excel file please?

  4. #4
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Help me improve my formula

    I hope I understood you
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-12-2020
    Location
    London
    MS-Off Ver
    MS Office 2019
    Posts
    3

    Re: Help me improve my formula

    Thanks for the help, sadly that's not what I meant but idk how to put it simply... I don't want the "Unit Price" to change (but the "Qty" can) and the "Total Price" are still around the same amount even with your formula and I don't want that

+ 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. VBA - Improve formula.
    By ozstrik3r69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2018, 02:06 PM
  2. Improve IF formula
    By magic2finger in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-04-2015, 04:05 AM
  3. Way to Improve SUMPRODUCT Formula
    By zmster2033 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-03-2015, 05:37 PM
  4. Improve/Shorten IF Formula
    By Saint02 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2010, 09:20 PM
  5. Can anyone please improve my formula?
    By B00105904 in forum Excel General
    Replies: 11
    Last Post: 06-29-2010, 11:55 AM
  6. [SOLVED] improve formula offset and indirect
    By John Contact in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. [SOLVED] How can improve this formula?
    By Metallo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-27-2005, 02: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1