Auditing A Spilling Range Formula

[Biz]

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

 

[kweaver]

The spill range is grayed out because they are all based on the initial formula which is the only one you can edit.

 

[Biz]

The spill range is grayed out because they are all based on the initial formula which is the only one you can edit.

Thank you for your help.
That's what thought too but hoped there's was another trick.

 

[kweaver]

Thank you for your help.
That's what thought too but hoped there's was another trick.

You'd have to rewrite the original formula to only address that cell rather than a range.

 

[Biz]

You'd have to rewrite the original formula to only address that cell rather than a range.

Yes, but I wanted to use spilled range formulas for the efficiency and consistency of the formula.

 

[kweaver]

So, this won't be satisfactory for you in CC11?

=ROUND(IFERROR(AZ11/AL11,0)*100,2)

 

[Biz]

So, this won't be satisfactory for you in CC11?

=ROUND(IFERROR(AZ11/AL11,0)*100,2)

Yeah, that's same formula I had before I decided to step into spillage range formula. Thank you for your help.