Mathmatical poser

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
In that case, there is more than 1 solution:

4^4/64 = 4 and 4^1/1^6=4 would both work.
 
In that case, there is more than 1 solution:

4^4/64 = 4 and 4^1/1^6=4 would both work.

The problem with 4^1/1^6=4 is that the 6 is already in the original equation as a regualar 6 and you need to change it to a superscript 6.
Minor detail I admit, but true none the less. Good thinking though.
 
Well, if they're going to go that route, the 6 is probably close enough to the = sign to prevent the insertion of the 4 after the 6 :-P :nya:
 
It's a neat puzzle - one I'd seen before, but it had been long enough ago that I'd forgotten the solution. But it is a bit "sneaky" in that when one says that you cannot insert another operator, the implication is that one cannot insert another operation which leads one to mentally cross using exponentiation from the list of things you can do.
 

Forum statistics

Threads
1,225,337
Messages
6,184,356
Members
453,228
Latest member
badaflash

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