SOLVED

Help with a IF function.

%3CLINGO-SUB%20id%3D%22lingo-sub-3266024%22%20slang%3D%22en-US%22%3EHelp%20with%20a%20IF%20function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3266024%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20do%20a%20function%20where%20if%20the%20invoice%20days%20past%20due%20is%20non-overdue%2C%20%26lt%3B10days%2C%2010-30days%2C%2031-60%20days%E2%80%A6etc%20the%20invoice%20amount%20will%20be%20placed%20in%20the%20appropriate%20column%20based%20on%20the%20date.%20So%20an%20invoice%20from%20Mar%2026%20would%20appear%20in%20the%20non-overdue%20column%20and%20on%20Apr%201%20would%20then%20jump%20to%20display%20in%20the%20%26lt%3B10day%20column.%20The%20formula%20I%20have%20is%3A%20%3DIF(CHOOSE(MATCH(TODAY()-%24F9%2C%7B-99999%2C0%2C31%2C61%2C91%2C99999%7D%2C1)%2C%22Future%20Date%22%2C%220-30%20Days%22%2C%2231-60%20Days%22%2C%2261-90%20Days%22%2C%22Over%2090%20Days%22)%3DH%241%2C%24C9%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3266024%22%20slang%3D%22en-US%22%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-3267114%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20IF%20function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3267114%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much%20it%20works%20perfectly%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3266507%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20IF%20function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3266507%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1342553%22%20target%3D%22_blank%22%3E%40Teyonka%3C%2FA%3E%26nbsp%3BPerhaps%20the%20attached%20file%20works%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to do a function where if the invoice days past due is non-overdue, <10days, 10-30days, 31-60 days…etc the invoice amount will be placed in the appropriate column based on the date. So an invoice from Mar 26 would appear in the non-overdue column and on Apr 1 would then jump to display in the <10day column. The formula I have is: =IF(CHOOSE(MATCH(TODAY()-$F9,{-99999,0,31,61,91,99999},1),"Future Date","0-30 Days","31-60 Days","61-90 Days","Over 90 Days")=H$1,$C9,"")

2 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

@Teyonka Perhaps the attached file works for you.

 

Thank you very much it works perfectly@Riny_van_Eekelen