How to get Escel to Recalculate a formula if the answer does not meat criteria

  • Thread starter Thread starter Al
  • Start date Start date
What is going to occur that will make a different result? In other words,
what good will recalculating do unless the values in A1, B1 or C1 changes?
Will they be changing and, if so, how?
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
 
A1,B1,C1 are selecting numbers randomly from a list. So I guess what I
really want to do is have A1,B1&C1 reselect until the sum is <10 (or
whatever criteria).
 
Check out Goal Seek in XL Help.

Al said:
A1,B1,C1 are selecting numbers randomly from a list. So I guess what I
really want to do is have A1,B1&C1 reselect until the sum is <10 (or
whatever criteria).
Click to expand...
 
Back
Top