Circular References

Hi Bayly,

In Excel, circular reference usually happens if you write a formula/function (e.g. Sum, Average, if statement...etc) on the source number cell.

Usually, formula/function should be placed on a blank cell.

If you get a circular reference warning, press Esc to cancel & press Esc again to abort the formula. Put in the formula again but in a blank cell.

Hope that clears it up.

Kind regards,

Katie Woo
Microsoft Certified Trainer