Dear All,
I'm new to spilled range formulas, and I would like to know how to audit the components of a spilled range formula. Specifically, I have a formula that spills across multiple cells (e.g., from cell CC7 to CC1081) using the formula =ROUND(IFERROR(AZ7:AZ1081/AL7:AL1081,0)*100,2).
However, when I navigate to a particular cell within the spilled range, such as CC11, I am unable to press F2 to access and audit the individual components of the formula.
Is there a way to enable the auditing feature for spilled range formulas, so I can review and understand the calculation of each cell within the range?
I would appreciate any guidance or suggestions on how to accomplish this. Thank you.
Kind Regards,
Biz
I'm new to spilled range formulas, and I would like to know how to audit the components of a spilled range formula. Specifically, I have a formula that spills across multiple cells (e.g., from cell CC7 to CC1081) using the formula =ROUND(IFERROR(AZ7:AZ1081/AL7:AL1081,0)*100,2).
However, when I navigate to a particular cell within the spilled range, such as CC11, I am unable to press F2 to access and audit the individual components of the formula.
Is there a way to enable the auditing feature for spilled range formulas, so I can review and understand the calculation of each cell within the range?
I would appreciate any guidance or suggestions on how to accomplish this. Thank you.
Kind Regards,
Biz