Time Nested IF Formula

[Seper825]

How can I limit scores of an event such as running by using nested if function in excel...Like 18 mins is 6 points and between 18 to 17:30 mins is 7 points and so on and so forth.....PS: Its only elapsed time.

[#2]

@Seper825 , that's better to do with LOOKUP, like

and in attached file

[#3]

Leme check and report back. Thnx buddy

[#4]

Leme check and report back.. thnx

[#5]

Thanks @Sergei Baklan ...it worked like a charm

[#6]

@Seper825 , you are welcome