excel 2013 formula help

Hello, 

I am trying to formulate the addition of c1+d1 if it is >= 171 then e1 is added to the sum with f1,g1,j1,k1 and totaled in l1.  

if any of the spaces are blank, then they are not read.

if the sum of c1+d1 is < 171, then the amount of e1 will be added to the sum of c1+d1 to = 171, if the remainder of e1 is zero then add to the sum of c1+d1+e1+f1+g1+j1+k1 to total in l1 with e1 being annotated as zero

if there is a remainder in e1 after the sum of c1+d1+e1 =171 then add f1+g1+j1+k1 to total in l1  

if any of the spaces are blank, then they are not read

          8.00 108.00

By: Wayovrmyhead

Leave a Reply

Your email address will not be published. Required fields are marked *