| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reducing the number of times an IF statement needs to be calculated in embedded IF statements
Hi,
I have a long formula that is getting too long. It has 3 embedded IF statements, with the logical test below having to be calculated each time. (Planning!X14/365.25)+1900-INT((Planning!X14/365.25)+1900) For example, when the logical test solves this to 2004, is there some way to store that "2004" in memory the first time and recall it as "2004" in the formula for the other two logical tests. Otherwise the formula is getting so long, and these three embedded IF are just a portion of a longer formula. In summary, is this possible to, in the middle of a formula, store something in memory and recall it from memory for use in other places in the formula? I think you'll say no, that's what VBA is for. That's ok, I just would like to know for sure. Thanks, Harold |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) | |||
| Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
| How do I limit the number of times an Excel workbook can be opene. | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
| how do I get a calculation to repeat various number of times? | Excel Worksheet Functions | |||
Threaded Mode
