if formula

[duckie]

I need help with the following I posted this a year or so ago and my
computer crashed
In column E, I have difference times like 14.5 seconds and other cells
in same column could have 12.1 or 13.4 and some cells are blank, it
is a score card for track and field program
in column AI it should come up as a number 3 or 2 or 1 as per sample

=IF(E8="",0,IF(E8=MIN(IF($AE$6:$AE$6>0,$AE$6:$AE$6)),2,IF(E8=MAX($E
$8:$E$35),1,IF(OR(E8<$AE$6,AND($AE$6=0,E8>0)),3))))

It doesn’t work out I hope this makes sense
i am happy to email the sheet to someone to help me

 

[Squeaky]

Hi Duckie,

In your formula you have a "Space" between the two items where there is a
line break. Specifically where your formula goes ... IF(E8=MAX($E <---RIGHT
HERE
$8:$E$35),1...

Repaste your formula into a cell, place your cursor in front of the $8 and
hit the backspace key. It will line the $8 back with the $E.

Or just copy this.

=IF(E8="",0,IF(E8=MIN(IF($AE$6:$AE$6>0,$AE$6:$AE$6)),2,IF(E8=MAX($E$8:$E$35),1,IF(OR(E8<$AE$6,AND($AE$6=0,E8>0)),3))))


Squeaky