Need help with formula based on Day of Week

%3CLINGO-SUB%20id%3D%22lingo-sub-2993474%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20formula%20based%20on%20Day%20of%20Week%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2993474%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20there%2C%20I%20am%20trying%20to%20make%20a%20formula%20in%20my%20excel%20spreadsheet%2C%20so%20in%20the%20event%20that%20it%20is%20Monday%2C%20it%20will%20return%20a%20value%20based%20upon%20that%20day%2C%20with%20the%20rest%20of%20the%20days%20with%20the%20same.%20The%20formula%20I%20have%20below%20doesn't%20seem%20to%20work%20and%20I'm%20not%20sure%20why.%3C%2FP%3E%3CP%3E%3DIFS(B1%3D(%22Monday%22)%2C(%2263%22)%2C(%22Tuesday%22)%2C(%20%2260%22)%2C%20(%22Wednesday%22)%2C(%2266%22)%2C(%22Thursday%22)%2C%20(%2265%22)%2C(%22Friday%22)%2C%20(%2266%22)%2C(%22Saturday%22)%2C%20(%2268%22))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%20provided.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2993474%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2993532%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20formula%20based%20on%20Day%20of%20Week%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2993532%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1226358%22%20target%3D%22_blank%22%3E%40Galadore91%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIFS(B1%3D%22Monday%22%2C%2263%22%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EB1%3D%22Tuesday%22%2C%20%2260%22%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EB1%3D%20%22Wednesday%22%2C%2266%22%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EB1%3D%22Thursday%22%2C%20%2265%22%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EB1%3D%22Friday%22%2C%20%2266%22%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EB1%3D%22Saturday%22%2C%20%2268%22)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThis%20formula%20works%20in%20my%20speadsheet.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2993587%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20formula%20based%20on%20Day%20of%20Week%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2993587%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174419%22%20target%3D%22_blank%22%3E%40Quadruple_Pawn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hey there, I am trying to make a formula in my excel spreadsheet, so in the event that it is Monday, it will return a value based upon that day, with the rest of the days with the same. The formula I have below doesn't seem to work and I'm not sure why.

=IFS(B1=("Monday"),("63"),("Tuesday"),( "60"), ("Wednesday"),("66"),("Thursday"), ("65"),("Friday"), ("66"),("Saturday"), ("68"))

 

Thanks for any help provided.

 

2 Replies

@Galadore91 

=IFS(B1="Monday","63",

B1="Tuesday", "60",

B1= "Wednesday","66",

B1="Thursday", "65",

B1="Friday", "66",

B1="Saturday", "68")

 

This formula works in my speadsheet.