Related:
- Quick Formula Help (Hopefully) Please!
- Quick cpu - Download - Diagnosis and monitoring
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
3 responses
I tried that and it told me that it was a circular calculation. I went in my preferences and changed the iteration settings, but it still tells me that it's false. I guess I cannot input a formula in a cell that will have its value fluctuate. Basically, I have two cells, when cell 2 becomes >0, I want cell 1 to reflect a subtraction of cell 1 from cell 2, while maintaining the value in cell 1. You have A1=10, and then A2=4, I would want A1 to automatically equal 6, whereas A2 still equals 4.
Again, your help is much appreciated!!!
Again, your help is much appreciated!!!
Ah! I get it! You cannot do that this way because of the circular reference indeed. I think you will have to write some code to accomplish that. I would create two sheets - one with all the static values and another one with the formulas. The formula would be referencing sheet 2 cells. If those numbers need to be updated frequently, I would perform the calculations via VBA.