Home

NEED HELP TO RESOLVE THIS IF STATEMENT

%3CLINGO-SUB%20id%3D%22lingo-sub-729719%22%20slang%3D%22en-US%22%3ENEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729719%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20in%20a%20dispatch%20office%20in%20a%20warehouse.%20I%20record%20the%20status%20of%20all%20trip%20numbers%20of%20company.%20Status%3A%20LOADING%2C%20SHIPPED%20OR%20DROP%20LOADED.%3C%2FP%3E%3CP%3EWe%20have%201st%20and%202nd%20shift%20group%20of%20forklift%20driver.%20I%20try%20to%20create%20a%20if%20statement%20condition.%26nbsp%3B%3C%2FP%3E%3CP%3ETRIP%20STATUS-Load%20Type-Name1-Time%20In%20A-Time%20Out%20A-Name2-Time%20In%20B-Time%20Out%20B%3C%2FP%3E%3CP%3Eif%20i%20type%20the%20time%20I%20want%20that%20the%20trip%20status%20automatically%20change%20its%20status%20from%20LOADING%20TO%20SHIPPED%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-729719%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729733%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368748%22%20target%3D%22_blank%22%3E%40LuisCortez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20post%20a%20spreadsheet%20with%20sample%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729737%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729737%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121681iC3B1C439F4BFA3B9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729803%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368748%22%20target%3D%22_blank%22%3E%40LuisCortez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20check%20if%20Load%20Type%20is%20equal%20to%20some%20string%20AND%20Shift%20Name%20is%20within%20C3%3AC28%20range%20AND%20Time%20In%20is%20within%20O3%3AO1442%20range%20-%20when%20COUNTIF%20for%20latest%20to%20conditions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-730145%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-730145%22%20slang%3D%22en-US%22%3E%3CP%3E%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%3EI%20try%20over%20and%20over%20in%20different%20ways%20and%20nothing.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121705i2C8145DE402CBEC9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture%202.JPG%22%20title%3D%22Capture%202.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-730147%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-730147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368748%22%20target%3D%22_blank%22%3E%40LuisCortez%3C%2FA%3EI%20tried%20this%20way%20too.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121706i0A8A2AF6EB267BA3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture%203.JPG%22%20title%3D%22Capture%203.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-730328%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-730328%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368748%22%20target%3D%22_blank%22%3E%40LuisCortez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you'd%20like%20to%20check%20if%20K2%20is%20equal%20on%20of%20C3%3AC28%20in%20sheet%20Data%2C%20when%20formula%20is%3C%2FP%3E%0A%3CPRE%3E%3DCOUNTIF(Data!C3%3AC28%2C%20K2)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
LuisCortez
New Contributor

I work in a dispatch office in a warehouse. I record the status of all trip numbers of company. Status: LOADING, SHIPPED OR DROP LOADED.

We have 1st and 2nd shift group of forklift driver. I try to create a if statement condition. 

TRIP STATUS-Load Type-Name1-Time In A-Time Out A-Name2-Time In B-Time Out B

if i type the time I want that the trip status automatically change its status from LOADING TO SHIPPED

 

 

 

6 Replies

@LuisCortez 

Can you post a spreadsheet with sample data?

Highlighted

@LuisCortez 

If you check if Load Type is equal to some string AND Shift Name is within C3:C28 range AND Time In is within O3:O1442 range - when COUNTIF for latest to conditions.

@Sergei BaklanI try over and over in different ways and nothing. 

Capture 2.JPG

@LuisCortezI tried this way too.Capture 3.JPG

@LuisCortez 

If you'd like to check if K2 is equal on of C3:C28 in sheet Data, when formula is

=COUNTIF(Data!C3:C28, K2)

 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies