Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Functions
Resolved · Low Priority · Version Standard
Susan has attended:
Excel Advanced course
What have i done wrong in my function to receive the error message 'circular reference'?
basically, you are linking in the cell that you are typing the formula in.
if you are typing in cell A1 something like =A1*4, then it can't od that because it's looking at it's own value and it will always be going round in circles to try and get a result
|
Excel tip:Hide columns in an Excel 2010 WorksheetIf you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns. |
We'll call during UK business hours
Server loaded in 0.09 secs.