| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get Escel to Recalculate a formula if the answer does not meat criteria
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get Escel to Recalculate a formula if the answer does not meat criteria
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). On Mar 26, 3:42 am, "Anne Troy" wrote: 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 Troywww.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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get Escel to Recalculate a formula if the answer does not meat criteria
Check out Goal Seek in XL Help.
In article .com, "Al" wrote: 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). On Mar 26, 3:42 am, "Anne Troy" wrote: 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 Troywww.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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Escel: Count students =20 and <=29 | Excel Discussion (Misc queries) | |||
| Recalculate Formula when field value changes | Excel Discussion (Misc queries) | |||
| adobe pdf to escel | Excel Discussion (Misc queries) | |||
| Lookup Multiple Criteria return One answer | Excel Worksheet Functions | |||
| how do I set up excel sheet for meal break down cost,labor,meat | Excel Worksheet Functions | |||
![Al[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
