Home » Messageboard »
Message 7887720
(Thread)
what's one of them?
(
Captain Wow currently being a cunt in Infamous, Thu 20 Dec 2007, 17:28,
archived)
It's an excel error
When a formula refers back to its own cell, either directly or indirectly, it is called a circular reference. Microsoft Excel cannot automatically calculate all open workbooks when one of them contains a circular reference. You can remove a circular reference, or you can have Excel calculate each cell involved in the circular reference once by using the results of the previous iteration. Unless you change the default settings for iteration, Excel stops calculating after 100 iterations or after all values in the circular reference change by less than 0.001 between iterations, whichever comes first.
Which is nice.
(
Dixipoos Bye Bye Blackbird, Thu 20 Dec 2007, 17:29,
archived)
I can only do one formula- vlookup.
And all of that that you just wrote- I tried to read it, really I did. I get to 'can remove circular reference' and then my brain just can't handle it.
(
Captain Wow currently being a cunt in Infamous, Thu 20 Dec 2007, 17:32,
archived)
You've broken maths
(
NinjaBadger Come see "The Room" in London- See Events Nov 28th, Thu 20 Dec 2007, 17:36,
archived)
Innee clever?
(
Captain Wow currently being a cunt in Infamous, Thu 20 Dec 2007, 17:36,
archived)
I feel I should admit to copying and pasting that from the Microsoft Office help pages
but I am afraid it will destroy your belief in my intellectual capabilities.
(
Dixipoos Bye Bye Blackbird, Thu 20 Dec 2007, 17:39,
archived)
I think you're clever anyway.
Destroy away!
(
Captain Wow currently being a cunt in Infamous, Thu 20 Dec 2007, 17:40,
archived)
Sometimes the smartest way out
is the easy way out
(
NinjaBadger Come see "The Room" in London- See Events Nov 28th, Thu 20 Dec 2007, 17:40,
archived)
If you want to find the best way to do something, give it to a lazy person.
(
Dixipoos Bye Bye Blackbird, Thu 20 Dec 2007, 17:42,
archived)
Like me?
I'm getting very good at delegating.
(
Captain Wow currently being a cunt in Infamous, Thu 20 Dec 2007, 17:44,
archived)
hahah that was a feedback I received recently!
"Dixon has started to learn the correct use and strength of delegation"
(
Dixipoos Bye Bye Blackbird, Thu 20 Dec 2007, 17:47,
archived)
:D
It's so nice when they applaud you for basically making others do your work.
Well done to you!
(
Captain Wow currently being a cunt in Infamous, Thu 20 Dec 2007, 17:49,
archived)
I'm off now.
*waves goodnight*
(
wheelybird Paul's out of toilet paper - send donations, Thu 20 Dec 2007, 17:36,
archived)
Nightynight!
(
Captain Wow currently being a cunt in Infamous, Thu 20 Dec 2007, 17:44,
archived)
like this:
this
(
The Alchemist robots: everywhere, eating old people's medicine, Thu 20 Dec 2007, 17:36,
archived)
Arrrggg!
Just like that.
(
robotic Murder Suicide Ducks War, Thu 20 Dec 2007, 17:38,
archived)