Iterative process w/conditional formula

  • Thread starter Thread starter fredtheengineer
  • Start date Start date
F

fredtheengineer

I want to establish an iterative process with a conditional formula as follows:
1. First condition: Is X<Y
2. If so add an incremental number to the existing content of a cell
3. Then recalculate the spreadsheet.
Any assistance will be appreciated. Thanks
 
Try explaining what you want to achieve instead of the technique.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want to establish an iterative process with a conditional formula as follows:
| 1. First condition: Is X<Y
| 2. If so add an incremental number to the existing content of a cell
| 3. Then recalculate the spreadsheet.
| Any assistance will be appreciated. Thanks
 
1. How do I increase the content of a cell by a specific increment (e.g.
0.01)?
2. Once that has been accomplished, how do I recalculate the entire sheet?
 
Try explaining what you want to achieve instead of the technique.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 1. How do I increase the content of a cell by a specific increment (e.g.
| 0.01)?
| 2. Once that has been accomplished, how do I recalculate the entire sheet?
|
| "Niek Otten" wrote:
|
| > Try explaining what you want to achieve instead of the technique.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > |I want to establish an iterative process with a conditional formula as follows:
| > | 1. First condition: Is X<Y
| > | 2. If so add an incremental number to the existing content of a cell
| > | 3. Then recalculate the spreadsheet.
| > | Any assistance will be appreciated. Thanks
| >
| >
| >
 
Back
Top