Locking a formula

Hi Leila,

Thank you for the forum question.

If you copy down, all fixed cell references will need to a $ in front of the row number. If you have a constant in, let us say in A1 and you don't want Excel to move down to A2 when you copy the IF function one row down you need to reference the cell A$1.

I do not know what the problem is with your IF, based on the few details in the question.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector