[SOLVED] Function tagging values with if statements

**tns5852** · 02-25-2010, 11:42 AM

I wrote a function to change a value in a cell to an ordinal number.

Please Login or Register  to view this content.

--- All postive values that get passed through the function return a value of "5." If I remove the postive value statements, I get the desired result for negative numbers. When I remove the last for lines, I get correct return of "1" for postiive values that satisfy the statement, however, if I remove the last three lines, I get a value of 2 for everything.

Is this function over defined? I don't understand why I can simply make nested if statements using If Else. I using Else and only got errors.

**JBeaucaire** · 02-25-2010, 01:12 PM

You are running every function. Just run it until it finds a match like so, maybe:

Please Login or Register  to view this content.

I'm having trouble with your ranges. Can you just make a table showing the ranges and the result so it's crystal clear?

**JBeaucaire** · 02-25-2010, 01:21 PM

Maybe this to order it and reduce required calcs:

Please Login or Register  to view this content.

**tns5852** · 02-25-2010, 02:51 PM

Thank you so much! I tried the second post you made and it works just fine. When I had originally tried writing the if statements, I did not include the final "Else End If"