Forum Discussion

yaya1974's avatar
yaya1974
Icon for Helper III rankHelper III
2 years ago

Formula Help

I am trying to subtract same column but different row, or previous period.  Everything I have tried keeps giving me the same value as in original column.   Here is screen shot of the output I am look...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

  1. 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
  2. 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
  3. Why does the first set of coloured cells in column D have 7 rows and the other sets have only 6 rows?