Forum Discussion
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...
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.
Please see the attached workbook. I believe it fixes the problem. Tweaked the formula a little bit.
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