Need a little help with =IF(AND(OR

**Lordirish** · 08-09-2017, 05:37 PM

Working on a player sheet for our group. We play table top games but would like to move the paper writing to excel. SO if they choose "Fighter" from the drop down menu for example I want it to post what it will take to get to the next level based on "Fighter" and current xp. I have spent two hours trying and failing so a little help would be GREATLY welcome.

This is as close as I can figure it example.

=IF(AND(OR(E2="Fighter",D2<="4000","4000",IF(AND(OR(E2="Fighter",D2<="2000","2000","0"))))))

**6StringJazzer** · 08-09-2017, 06:07 PM

If that formula doesn't do what you want, then showing it to us won't tell us what you want to do.

Can you please spell out what your paper process is so we can give you the right formula? What is that value in D2?

Also, do not put numbers in quotes.

**Lordirish** · 08-09-2017, 06:15 PM

Thanks for pointing out not putting " around the numbers. I am getting error: Wrong number of arguments to IF. Expected between 2 and 3 arguments, but got 1 argument. I will try my best to break down the process here in a little while, but in class at the moment.

**Lordirish** · 08-09-2017, 06:32 PM

I have sheet label PC, cell A6 is the class drop down menu. The player can choose Fighter, Paladin, Ranger, Thief, Mage, Illusionist, Cleric, Bard.
Cell E9 is their current level. This will be where it displays their current level based on their class and current xp.
Cell G9 is where they enter their daily xp from the game which adds it to E11 which is current xp.
Then on sheet labeled Table
D2 =PC!E11
E2 =PC!A6

What I want to do is is show what it will take to go to the next level.
The may have chosen Fighter and have 300xp it will show it takes 2000 to reach the next level. Or Thief will take 1250.

**jeffreybrown** · 08-09-2017, 07:00 PM

Take a look a building a Lookup table

**Lordirish** · 08-09-2017, 07:51 PM

Thanks, still not finding what I need but have a feeling I am getting close. I guess the best way to describe it is I am trying to use VLOOKUP dependent on two values,( a string and a number), then getting results back from multiple tables. Sorry I am ok with the basic skill in Excel but really trying to delve into the higher functions.

**jeffreybrown** · 08-09-2017, 09:39 PM

Originally Posted by Lordirish

Thanks, still not finding what I need but have a feeling I am getting close.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Lordirish** · 08-09-2017, 09:42 PM

Ok not what I wanted but works for now, just going to be a very long code by the time I am done lol.

Example of code
=IF(AND(E2="Fighter",D2>=2750000),3000000,IF(AND(E2="Fighter",D2>=2500000),2750000,IF(AND(E2="Paladin",D2>=3300000),3360000,"")))

So far works spotless but have a lot to put in. Thank you all for your help.