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
|