Forum Discussion

marc47555's avatar
marc47555
Copper Contributor
Apr 16, 2020
Solved

Excel formula help

Good Day,   I will try to explain to the best i can what i am trying to do!? i have uploaded the image with a better view to understanding what i am trying to achieve.   i basically have a list o...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Apr 16, 2020

    marc47555 

    Replicated your sheet and believe that this formula will do what you need.

    =IF((SUM(F$5:F5)+$D6-SUM($E6:E6))<=9,$D6-SUM($E6:E6),9-SUM(F$5:F5)+SUM($E6:E6))

     Important that column E remains empty and the the headers in row 5 are text (i.e. not numbers) or that you insert an empty row 5. Enter the formula in F6 and copy it down and across as far as you need.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 16, 2020

marc47555 

Replicated your sheet and believe that this formula will do what you need.

=IF((SUM(F$5:F5)+$D6-SUM($E6:E6))<=9,$D6-SUM($E6:E6),9-SUM(F$5:F5)+SUM($E6:E6))

 Important that column E remains empty and the the headers in row 5 are text (i.e. not numbers) or that you insert an empty row 5. Enter the formula in F6 and copy it down and across as far as you need.

marc47555's avatar
marc47555
Copper Contributor
Apr 16, 2020

Riny_van_Eekelen That works perfectly thank you so much!! i have been trying to work this out for WEEKS!

    • marc47555's avatar
      marc47555
      Copper Contributor
      Apr 16, 2020

      Riny_van_Eekelen it did thank you, how ever now they have told me i cant have more than 3 different layers on a pallet, ( layers are separate products ) I'm not sure if this is possible!? thanks anyway

Resources