Forum Discussion
Formula Help
Sorry. I can send another pic. But basically the the code below works for me except it is not filling in all the rows. Do you know why or what I need to change to get the rows to fill in?
Thank you!
Hi,
I will need a file to work with. So share the download link of the file with your Excel formulas intact.
see if this link works.
Thank you
Hi,
I cannot understand the logic of the average formula which you have written in column C. Please explain that clearly.
Column C don't matter. that code is working exactly how I need it to in powerbi. I need a code to calculate the adjustment from column C with a 3% threshold. the average is a look back period and the adjustment is the difference between the two periods. I have the code working, it just isnt filling in all the rows with "same" number for the 6 months. Either I need to take something out of my code or add something to get this to work. That is what I am asking. To alter the code that I already that is working. Thank you
Hi,
- I wonder what is the use of the IF() function in column D when the result is the same in the value if true and value if false placeholders i.e. $C$56-$C$55
- What should the trigger be for changing the range reference of the average function in column D i.e. when the number in column C changes
- Why does the first set of coloured cells in column D have 7 rows and the other sets have only 6 rows?