ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calculation based on entry into one of 2 cells (https://www.excelbanter.com/excel-programming/393566-calculation-based-entry-into-one-2-cells.html)

[email protected]

Calculation based on entry into one of 2 cells
 
I am trying to use excel to calculate a result for cell one on entry
into cell two or conversely calculate the value of cell two on entry
into cell one. I have found a solution for this on a previous post I
located using targets and conditional calculations.

The difficulty I have though is I have entries into other cells that
are needed for the calculation and I cannot get the thing to
recalculate based on entries into the other cells or what the proper
logic should be. May on entry into these other cells I null out cell
one and two until all the cells and one of cell one or two have
entries.

What makes sense here??

Thanks for any help.



All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com