Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

copy a formula

Copper Contributor

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 instance =d3/12.  I then need to copy that formula for the remaining 11 months with d3 being in each cell.

3 Replies

@tplant23 

This is an Excel 365 formula

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

 

Thanks, how do I make this go horizontal instead of verticlal?

@tplant23 

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