V
vinimall
can anyone help I'm new to excel formula,
I want to find a function that will help me calculate the following:
I'm a coach in athelitics, if my runners get below a certin time they
go into a group "intermediat group"
if they are above a certin time they go to the "advanced group"
I need the formula to show nothing in the speadsheet and then when a
time is entered it produces what group the athlete will be best suited
to.
Criteria:
Less than 2 minutes = Advanced group
More than 2 minutes = intermediate group
and I need the cell to show nothing untill a time is entered
Hope someone can help
I want to find a function that will help me calculate the following:
I'm a coach in athelitics, if my runners get below a certin time they
go into a group "intermediat group"
if they are above a certin time they go to the "advanced group"
I need the formula to show nothing in the speadsheet and then when a
time is entered it produces what group the athlete will be best suited
to.
Criteria:
Less than 2 minutes = Advanced group
More than 2 minutes = intermediate group
and I need the cell to show nothing untill a time is entered
Hope someone can help