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.

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

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

        Riny_van_Eekelen  Thank you so much for you help the other day, those formulas work perfect for 3 of my sheets! 🙂 

         

        how ever i have had to amend a sheet i have attached below with a note with what is needed im hoping you could help if not then thank you for trying .

         

        Marc

         

Resources