Friday Poser

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
No, but I'm curious what yielded 992?

Note: Upon reflection this may not be a fair sequence, so I will leave it until noon then post the answer.

Er, I can't seem to replicate it. I confess that I never made it far enough in school to cover this sort of subject. :confused:
 
Solution: (A1 Xor A2) + A1... copy down.

I was trying to see if there was a mathematic way to replicate Xor, but the formula got ridiculous and that was when I was like "hmmm that may not have been fair". (BTW extra points for anyone who knows a simple way to do that with math operators)
 
Last edited:
An Excel way could be:

=(OR(A1=7,A2=9)<>AND(A1=7,A2=9))
 
For XOR perhaps

=(A1=7)+(A2=9)=1

....as for 1040 I still don't see why it should be the next in the series. My answer (1040 or 1072) was based on the logic being

n+1 = (n+/-8)*2

but I couldn't work out when it was +8 and when it was -8......
 
....as for 1040 I still don't see why it should be the next in the series.

Theoretically, any formula that replicates the number sequence given would be "right". The Xor formula is just righter by virtue of being the one I used:)
 
OK, what's the next number in the sequence?

1, 7, 25, 61, 121, 211, ?
 

Forum statistics

Threads
1,222,653
Messages
6,167,363
Members
452,111
Latest member
NyVmex

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