France 2 England 1

[Corleone]

Is there anything you can do on Excel to change what happened in injury time?

 

[plettieri]

Hi:

Seems likey a possible move to the discussion group forum for this topic, but unfortunately that is closed....

plettieri

 

[Smitty]

Is there anything you can do on Excel to change what happened in injury time?

I dunno. What happened, and what are you trying to accomplish?

Maybe post a shot of your sheet.

Smitty

 

[PaddyD]

Book1
	A	B	C	D
1		England	Anyotherteamontheplanet
2	SuggestedScore
Sheet1

There is data validation on B2 as follows:

=C2>B2

with the corresponding message:

"You have entered a score that implies that England might win a game of football. The probability of this is lower than the smallest number Excel can store (1E-307) - please enter a more realistic number, or contact Mirosoft to ask that they enable the storage of numbers small enough to represent England's chances of winning a game".

 

[Corleone]

Cheers

 

[Expiry]

In the history of Mr Excel, has anyone had to wait longer for a 'thank you' than this?

 

[Domski]

WTF!!! That's priceless!!!

Dom

 

[Jon von der Heyden]

Corleone, I take it you didn't put any money on England winning the cup this time, since Paddy gave you a validation rule preventing a winning score.

 

[Greg Truby]

In the history of Mr Excel, has anyone had to wait longer for a 'thank you' than this?

Well, you have to admit, that's most impressive, six years down to the minute.

 

[davesexcel]

That is amazing!! It is the talk of the XL Forum World, I had to see it for Myself.
Though it appears to be 1 hour short of six years, LOL