Forum Discussion
Constant number divided depending on IF Parameters
I could be completely off with this, but I'm trying to do something which in my head is very simple, but my brain will not process the formula. Essentially, in cell I2, I have a number that is pr...
If your base value was the same for each day but the target had some days 50% higher than others, the formula
= LET(
modified, IF(option="yes", 1.5, 1) * base,
modified / SUM(modified)
)would scale the values where the option is set, but then renormalise to give the same weekly target. Is this what you require?
- The Value in I2 is the base number, however this will change based on data on another sheet.
Essentially what you're suggesting sounds correct. I2 will remain at Total Sales of 21,010
Other cells along that same row, will update depending on Yes or No, and the remaining cells will automatically adjust value down if other cells have increased.
Am I able to insert that code into Office365 or is that only possible on desktop version?The code will work with 365 online but, without Name Manager, it will be difficult to prepare. I only use defined names, never direct cell references, so I have simply avoided the online version despite its strengths for collaborative development. It is probably time I gave it another go!
