How to Remove Popups?: Breaking down a cell value into different cells

Breaking down a cell value into different cells

Hi,

Basically, what i'm trying to do is to have a certain number of cells that show the the value of another cell divided by the amount of cells that are active.

For example, lets say the main figure is 80, and I have four cells below that I want to show 80/4, thus 20, but what i also want to be able to do is that if i put a zero into one of the four cells, for the other three cells to represent 80/3 rather 80/4,
or if two of the four cells had a 0 in for the other two to show 80/2 and so forth

Any ideas?

Kind regards

Solutions to the Problem Breaking down a cell value into different cells

Download SmartPCFixer for Free Now

Boot in Safe Mode:

Open Run command as previously described
Type MSConfig
Click on Boot tab
Tick Safe boot in Boot option
Select Network
Click Apply and OK
Reboot your system

Your system will boot in Safe mode with Networking. You may now try and open Windows Store and should not see any errors.

Recommended Method to Fix the Problem: Breaking down a cell value into different cells:

How to Fix Breaking down a cell value into different cells with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.