I am making an excel file that should convert the distance jumped by a
person to a specific rank. For example if the distance was greater or
equal to 34, he would get a 10. and 34 distance = 32, he would get a
9 and so on...

Here's my dilema;

I need a formula that will should nest more than 7 functions, in this
case it wont work right? So what I did was name 2 separate fuctions for
example

1st fuction is


Code:
--------------------
=IF(B8=34,10,IF(B8=32,9,IF(B8=30,8,IF(B8=28,7, IF(B8=26,6,IF(B8=24,5,IF(B8=22,4,IF(B8=20,3,FA LSE))))))))
--------------------


and the 2nd fuction is


Code:
--------------------
=IF(B8=18,2,IF(B8<=16,1,1))
--------------------


I name the 1st function vJump1 and the 2nd fuction vJump2. Both of the
functions are below the actual table and will be hidden.

As you can see, they all look for the values in B8, and in cell B9,
this is what I would put :
Code:
--------------------
=IF(vJump1,vJump1,vJump2)
--------------------


It works and all and even made a few tweaks to make it work with
different values and exercises as well (sit ups, pull ups and so
on...).

All in all, I have 18 names for the 9 exercises. The problem is, when I
want to make inputs for the next week, I put it in another column (D8,
F8, H8 ...). And thus, I have to copy the fuctions that i made and name
them differently. It is very tidious and time wasting to do this. Also,
I am taking records for 8 other men(one worksheet for each person), so
that means, I'd have to name more than a hundred names.

Can anyone help me? Is there any other way to solve my problem? Can
anyone point me to a tutorial? I'm just a teenager who has basic excel
knowhow.

If it helps, I attached the file.


Thanks,
Peds


+-------------------------------------------------------------------+
|Filename: ADMU BCPR Edited 2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4936 |
+-------------------------------------------------------------------+

--
t43m4n
------------------------------------------------------------------------
t43m4n's Profile: http://www.excelforum.com/member.php...o&userid=35536
View this thread: http://www.excelforum.com/showthread...hreadid=555346