View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy[_2_] Anne Troy[_2_] is offline
external usenet poster
 
Posts: 221
Default How to get Escel to Recalculate a formula if the answer does not meat criteria

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" wrote in message
oups.com...
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)