Predict The Output III

How many did you get right?

  • Zero

    Votes: 6 37.5%

  • 1

    Votes: 2 12.5%

  • 2

    Votes: 6 37.5%

  • 3

    Votes: 2 12.5%
  • Total voters
    16
Re: Predict The Output II

It's been switched over to a private poll. I think it reset the votes so anyone who had already voted might have to re-vote.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Re: Predict The Output II

The 0 option seems to be missing too.
 
Re: Predict The Output II

Hi Richard,

Two people had voted 0 which isn't a choice on the poll anymore.

Cheers
 
Re: Predict The Output II

For some weird reason it won't accept '0' as a poll question when it's a private poll so I've replaced with Zero. All scores have been zeroed out I'm afraid.
 
Re: Predict The Output II

I don't get the code. And I don't get Rory's jokes. Feel thick now!
 
Re: Predict The Output II

That reminds me - when are you due to pop?
 
Re: Predict The Output II

Couple of months. If it doesn't claw its way out first. (Having particularly uncomfortable day today! :biggrin: )
 
Re: Predict The Output II

The first two didn't cause me any problems. But the NOT 2 bucked off and into the dirt. Completely didn't expect that one. What I had expected to see would more or less have been the same as
Code: 
? not(cbool(2)) + 0
I still ain't quite sure of the logic on that one. I understand arithmatically what it's doing. But I don't get why MS would program it to behave like that.
 
Last edited:
You must log in or register to reply here.

Forum statistics

Threads
1,222,647
Messages
6,167,331
Members
452,110
Latest member
eui

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top