# How to do Reverse Multiplication In Excel?

1. ## 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. ## 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.

3. ## 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

4. ## Re: How to do Reverse Multiplication In Excel?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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