Setting Up Formulas

Hello Trish,

When writing a formula you specify cell refs e.g. B1 or C3 etc.. If you copy the formula, the cell reference is relative, meaning it will follow your formula. So if you were to copy your formula across 2 columns, then the cell reference in the formula will also move 2 columns.
Should you not wish this cell ref to move, specify the Dollar $ sign around the cell ref to "lock" it into position.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer