Experienced in Excel?

[500bloc]

Re: Experienced in Excel?

Now it looks like the real work is ahead of you...evaluating players in all those categories!

Well if u play 2k10, maybe one day this will be of use to u.


I have another question, say that when I write a formula, I don't want the answer to go below the number 25. How would I go about that?

[Trevytrev11]

Re: Experienced in Excel?

If you want 25 to be the min value then you have to use an IF statement that basically says: if the output of the formula is less than 25, use 25, if not, use the output.


It would look something like this:

=IF((B5+C5)<25,25,(B5+C5))


In this case, your formula would replace what is inside of the ( )..in this case (B5+C5).

Any time your output is less than 25, you will get a 25, anything over that will be the actual output.

[Cardot]

Re: Experienced in Excel?

Yeah, the "If" formulas in Excel aren't as readable as some other programming languages that also include the "Then" & "Else" words.

So the formula that Trev wrote is basically:
If B5 + C5 is less than 25
then the resut is 25
Else the result is B5+C5

=IF((B5+C5)<25,25,(B5+C5))

Sorry if this was already obvious.

[500bloc]

Re: Experienced in Excel?

This is my original formula:


=(BO3*AX3)*100+35



My new formula based on the advice given is this:


=IF((BO3*AX3)*148+25)<25,25,(BO3*AX3)*148+25


Am I correct? Because I'm getting #Name? when I imput this, so I must be doing something wrong.

[Cardot]

Re: Experienced in Excel?

Try this:

=IF(BO3*AX3*148+25<25,25,BO3*AX3*148+25)

[500bloc]

Re: Experienced in Excel?

Try this:

=IF(BO3*AX3*148+25<25,25,BO3*AX3*148+25)

I got a Err:509

[Trevytrev11]

Re: Experienced in Excel?

I got a Err:509

When you enter these forumla's are you keying them in or just copying and pasting them from here? Make sure there are no spaces,etc. I've just never seen these errors you are receiving.

It may not matter, but try this one, I'm a bit of a ( ) whore when it comes to writing formula's, but again it may be all for nothing:

Instead of this:

=IF(BO3*AX3*148+25<25,25,BO3*AX3*148+25)

Write this:

=IF((BO3*AX3*148+25)<25,25,(BO3*AX3*148+25))

It shouldn't matter as excel uses the comma to break up the if, then, else parts of the formula.

When I just copy this (actually both of these formulas) from here and paste them into the forumla bar in excel, it's returning a value (25 - as I have no other data), so if you are getting an error, it may have something to do with your excel.

[Cardot]

Re: Experienced in Excel?

I also have never gotten that 509 error, but when I looked online, there were comments about HTML characters etc....so I agree with Trevy, I think it may have been a cut and paste issue. Trying typing it out. If it works, then copy and paste it the rest of the rows.

[500bloc]

Re: Experienced in Excel?

Thanks, once again I appreciate the help both of you have given me.