Multiplication with @row or @cell formula

annie.wong107591

I like to use the @row or @cell in a multiplication formula and be able to copy this for all months.  where do type in @cell? 

 

Paul Newcome

You would need an @row function and use the $ to lock in certain references.

 

Your current formula:

 

=[FY Budget]3 * [1]2

.

First lock in the [FY Budget] column reference.

=$[FY Budget]3 * [1]2

.

Then replace the [FY Budget] row reference with @row

row * [1]2

.

Then lock in the row reference for [1]

=$[FY Budget]@row * [1]$2

.

You can now copy/paste, autofill, or dragfill this formula to suit your needs.