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

[Al]

It`s a simple equation: =A1+B1+C1
But I need it to continue to recalculate automatically if the sum is

= 10.

EG: =if(A1+B1+C1>=10,recalculate)

 

[Anne Troy]

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
****************************

 

[Al]

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).

 

[JE McGimpsey]

Check out Goal Seek in XL Help.

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).