nested if formula question

[indiana115]

According to bits ive found excel only supports up to seven conditions. Is there a means to check up to 12 conditions? Thanks.

[AliGW]

Consider using a lookup table instead.

In more recent versions of Excel you can use up to 64 nested IFs, I think.

[ChemistB]

In Excel 2003 and earlier, it only supported 7 IF's. However, there are usually better ways to set up a worksheet than with 15 IF statements. (maybe a VLOOKUP, or INDEX/MATCH Formula). If you upload an example showing what you are trying to do, we might be able to get you a simplier way of doing it (Go Advanced>Manage Attachments)

[martindwilson]

1, excel 2007 and later support about 64 nestings
2,its usually easier to make a table and use a vlookup or lookup or index match

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[indiana115]

That being said, the vector value can equal a formula, correct?

[AliGW]

That being said, the vector value can equal a formula, correct?

A small lookup array can be nested within a formula, but I would use a lookup table for any amount of data.

[Tony Valko]

That being said, the vector value can equal a formula, correct?

Yes. _____

[indiana115]

Whats going on is i have a sliding points scale if there are less than sixteen players. Im trying to find the easiest way for it to adjust the points formula to lookup the proper percentage. Formula being d2*50*required percentage based on player count

[AliGW]

Can you give a worked example?

[indiana115]

Basically 1st place has 12 potential percentages to run the formula 2nd has 10 potential percentages and so on down to the tenth place person having 4 potentials. 11th-16th equal tenth place points

[indiana115]

If theres 16 or more players 1st. Place formula is d2(player count)*50(points in the pool per player)*.2(percentage of points awarded. If there is less than 16 players the percentage of points awarded changes for the first through tenth positions. Say the player count is 13. Percenatage awarded to first jumps to .23

[oeldere]

@indiana115

Maybe I can't help you with your question.

Since your new on the forum I suppose you don't know all "rules".

But you get better help if you follow the advice of the forummembers.

You want help, so help the forummembers.

So => please add the excel-file, without confidential information, according to the questions of the forummembers.

[indiana115]

Lookup table worked wonderfully. Thank you

[AliGW]

You're welcome!