if formula
 

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$60,$AE$6:$AE$6 )),2,IF(E8=MAX($E
$8:$E$35),1,IF(OR(E8<$AE$6,AND($AE$6=0,E80)),3))) )

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

if formula
 

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$60,$AE$6:$AE$6 )),2,IF(E8=MAX($E$8:$E$35),1,IF(OR(E8<$AE$6,AND($A E$6=0,E80)),3))))


Squeaky

"duckie" wrote:

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$60,$AE$6:$AE$6 )),2,IF(E8=MAX($E
$8:$E$35),1,IF(OR(E8<$AE$6,AND($AE$6=0,E80)),3))) )

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