Home

Time Nested IF Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-391961%22%20slang%3D%22en-US%22%3ETime%20Nested%20IF%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391961%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20limit%20scores%20of%20an%20event%20such%20as%20running%20by%20using%20nested%20if%20function%20in%20excel...Like%2018%20mins%20is%206%20points%20and%20between%2018%20to%2017%3A30%20mins%20is%207%20points%20and%20so%20on%20and%20so%20forth.....PS%3A%20Its%20only%20elapsed%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-391961%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401249%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20Nested%20IF%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401249%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F311931%22%20target%3D%22_blank%22%3E%40Seper825%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401242%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20Nested%20IF%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401242%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B...it%20worked%20like%20a%20charm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391993%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20Nested%20IF%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391993%22%20slang%3D%22en-US%22%3ELeme%20check%20and%20report%20back..%20thnx%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391990%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20Nested%20IF%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391990%22%20slang%3D%22en-US%22%3ELeme%20check%20and%20report%20back.%20Thnx%20buddy%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391987%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20Nested%20IF%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F311931%22%20target%3D%22_blank%22%3E%40Seper825%3C%2FA%3E%26nbsp%3B%2C%20that's%20better%20to%20do%20with%20LOOKUP%2C%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20536px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F100814iBE1F1785457065F8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20in%20attached%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E
Seper825
New Contributor

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.

5 Replies

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

image.png

and in attached file

Leme check and report back. Thnx buddy
Leme check and report back.. thnx
Highlighted

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

@Seper825 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies