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