Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |