You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I’m trying to create a cell that contains a formula which can be auto filled down. I need certain values within the formula to change as they normally would when autofilling, but others I want to stay exactly the same. Is there any way to do this?
iPad Pro, iOS 13
Hi Sean,
The absolute reference operator ( $ ) is your friend here.
$A$1 + $B1 + C$2
If this formula were entered as shown in cell D11, then filled down to D20, the formula in
D20 would be: $A$1 + $B10 + C$2
If the formula in D11 were filled right to N11, the formula in
N11 would be: $A$1 + $B1 + M$2
and if filled down and right (or filled right and down) to
N20, would be: $A$1 + $B10 + M$2
Regards,
Barry
Hi Sean,
The absolute reference operator ( $ ) is your friend here.
$A$1 + $B1 + C$2
If this formula were entered as shown in cell D11, then filled down to D20, the formula in
D20 would be: $A$1 + $B10 + C$2
If the formula in D11 were filled right to N11, the formula in
N11 would be: $A$1 + $B1 + M$2
and if filled down and right (or filled right and down) to
N20, would be: $A$1 + $B10 + M$2
Regards,
Barry
Oh that’s perfect, thanks!!
AutoFilling: Keeping Certain Values the Same?
