Help With IF Function

Copper Contributor

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