Forum Discussion

tplant23's avatar
tplant23
Copper Contributor
Jan 13, 2024

copy a formula

I am trying to copy a forumal that needs to maintain the original cell.  I am trying to do a budget where the annual total is X and then have the 12 months extended.  The first formula would be for i...
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jan 13, 2024

tplant23 

This is an Excel 365 formula

= IF(SEQUENCE(12), annualTotal/12)

 

  • tplant23's avatar
    tplant23
    Copper Contributor
    Jan 13, 2024
    Thanks, how do I make this go horizontal instead of verticlal?
    • PeterBartholomew1's avatar
      PeterBartholomew1
      Silver Contributor
      Jan 14, 2024

      tplant23 

      Place a comma before the 12 in SEQUENCE.  The first parameter is the number of rows and the second the number of columns.

Resources