+ Reply to Thread
Results 1 to 4 of 4

How to do Reverse Multiplication In Excel?

  1. #1
    Registered User
    Join Date
    12-07-2015
    Location
    Place,Place
    MS-Off Ver
    365
    Posts
    2

    Unhappy How to do Reverse Multiplication In Excel?

    I don't know how to explain it, but basically what I'm saying is how do I do something like this.

    I'm working on formulas for a simple RPG. Im trying to calculate how much XP certain monsters give you. Here is my basic formula:

    =SUM(D2*10*D3)

    D2 is equal to 10 (the player's level) D3 is equal to 15 (the monster's level) and 10 is a modifier.

    Now given that, it assumes that the farther you are behind the monster in level, the less XP you will get for that monster. So for the formula given above, that would give me 1500 XP for that monster. However, if my player level is 1 and I kill a level 15 monster, Id get 150 XP for the monster which doesn't make any sense. What I am trying to do is make it so that the farther behind the monster's level you are, the more experience you will get for it. Is there a difference formula that I can someone put in there? Also, if I wanted to make that formula more comlpex, something like this:

    =SUM(D2:G1*10*D3:G1)

    A mix of multiplication and addition. However, when I try to do something like that it gives me an error about keeping excel from doing the formula of 1+1.

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    544

    Re: How to do Reverse Multiplication In Excel?

    Maybe something along the lines of:
    Please Login or Register  to view this content.
    Edit: And as for the last formula.....SUM won't work over rows AND columns.
    Are you looking for an array there? maybe post a sample sheet with the results you are looking for.
    Or does G1 refer to a single cell you want added to the formula?
    And also, don't forget that most rpg's require much more xp as you level. So 150 xp at level 1 might still be a much higher % of a level then 1500 xp at level 10.

    Edit 2: Also might need to add in a qualifier so that a level 10 player killing a level 2 monster doesn't lose xp

    I think protonLeah's modifier table might be the way to go.
    Last edited by Beamernsw; 12-08-2015 at 01:00 AM.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,739

    Re: How to do Reverse Multiplication In Excel?

    So what XP does a L1 player get for a L15 mon if not 150?

    maybe you need a modifier table with Monster 1 - 15 across the top and player 1 - ? down the side. So for L1 player, the values would increase across the row to some max value for M15 then you would use a lookup formula to get the modifier based on PL vs ML


    *Note that you do not need SUM(), the formula is just =D2*D3*10

    So, build the table and post your workbook for help on the lookup formula
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    12-07-2015
    Location
    Place,Place
    MS-Off Ver
    365
    Posts
    2

    Re: How to do Reverse Multiplication In Excel?

    Thanks for your help everyone!

+ 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. multiplication and division Excel magic?!
    By SlaveII in forum Excel General
    Replies: 1
    Last Post: 02-08-2015, 07:19 AM
  2. [SOLVED] Multiplication Bug - Excel (Office) 2010
    By mgs in forum Excel General
    Replies: 5
    Last Post: 05-05-2014, 03:09 AM
  3. Getting Excel multiplication to ignore minus numbers
    By KeiranMac in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-23-2013, 08:36 PM
  4. Excel Multiplication Miscalculation
    By yawnzzzz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-02-2011, 05:11 PM
  5. multiplication formula in excel
    By v.muruganandam in forum Excel General
    Replies: 2
    Last Post: 07-25-2009, 01:30 AM
  6. Excel Can't Multiply...why is simple multiplication incorrect?
    By JBeaucaire in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2008, 11:55 PM
  7. [SOLVED] Matrix Multiplication:Excel SOMETIMES
    By Matrix Bill in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2005, 02:05 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