Help With IF Function

%3CLINGO-SUB%20id%3D%22lingo-sub-3114952%22%20slang%3D%22en-US%22%3EHelp%20With%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3114952%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20helpful%20people%3C%2FP%3E%3CP%3EI%20have%20a%20large%20spreadsheet%20which%20converts%20raw%20transactional%20data%20into%20a%20Pivot%20table%20to%20summarise%20the%20total%20value%20of%20transactions%20on%20a%20monthly%20basis%20(B%20to%20J).%26nbsp%3B%20I%20want%20to%20use%20the%20pivot%20table%20data%20to%20then%20populate%20the%20adjacent%20table%20in%20columns%20L%20to%20U%20to%20show%20the%20accumulated%20total%20in%20the%20month%20but%20only%20when%20the%20total%20is%20%24750%20or%20more.%26nbsp%3B%20Using%20the%20below%20as%20an%20example%20I%20am%20trying%20to%20get%20the%20following%20to%20work%20automatically%20using%20nested%20IF%20functions%3A%3C%2FP%3E%3CP%3ERow%202%3C%2FP%3E%3CP%3EAs%20B2%20%26lt%3B%20%24750%20display%200%20at%20M2.%26nbsp%3B%20If%20however%20B2%20was%20%26gt%3B%3D%20%24750%20display%20B2%3C%2FP%3E%3CP%3EAs%20M2%20%3D%200%20and%20B2%2BC2%20%26lt%3B%20%24750%20display%200%20at%20N2.%26nbsp%3B%20If%20however%20B2%20%2B%20C2%20%26gt%3B%3D%24750%20display%20result%20of%20B2%2BC2%3C%2FP%3E%3CP%3EAs%20N2%20%3D%200%26nbsp%3B%20and%20B2%3AD2%20%26gt%3B%3D%20%24750%20display%20result%20of%20B2%3AD2%20in%20O2%20etc%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEssentially%20once%20the%20threshold%20of%20%24750%20is%20met%2C%20I%20need%20it%20to%20restart%20the%20test.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SOAK01_0-1643942602597.png%22%20style%3D%22width%3A%20830px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345212i12296F2EBFBC4D9E%2Fimage-dimensions%2F830x55%3Fv%3Dv2%22%20width%3D%22830%22%20height%3D%2255%22%20role%3D%22button%22%20title%3D%22SOAK01_0-1643942602597.png%22%20alt%3D%22SOAK01_0-1643942602597.png%22%20%2F%3E%3C%2FSPAN%3E%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-3114952%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
Visitor

Hello helpful people

I have a large spreadsheet which converts raw transactional data into a Pivot table to summarise the total value of transactions on a monthly basis (B to J).  I want to use the pivot table data to then populate the adjacent table in columns L to U to show the accumulated total in the month but only when the total is $750 or more.  Using the below as an example I am trying to get the following to work automatically using nested IF functions:

Row 2

As B2 < $750 display 0 at M2.  If however B2 was >= $750 display B2

As M2 = 0 and B2+C2 < $750 display 0 at N2.  If however B2 + C2 >=$750 display result of B2+C2

As N2 = 0  and B2:D2 >= $750 display result of B2:D2 in O2 etc

 

Essentially once the threshold of $750 is met, I need it to restart the test.

Thanks

SOAK01_0-1643942602597.png

 

 

0 Replies