| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Save result of IF function
3 A B C D E 4 Date Number Result 1 Result 2 Date 5 15/02/2009 1345.5 15/02/2009 6 16/02/2009 Hi, Don't know if this makes any sense to anybody but I'll give it a try anyway. I can set up an IF formula in C5 to send contents of B5 to C5 if the date in A5matches the date in E5. My problem is:- How or what do I have to do to the formula to be able to "Save" that result in C5 even when the contents of A5 & B5 change. Because then there is another IF formula in D6 to send the new contents of B5 to D6 if the new date in A5 matches the date in E6. Any help in this matter is appriciated. Becky -- Rebbeca ------------------------------------------------------------------------ Rebbeca's Profile: http://www.thecodecage.com/forumz/member.php?userid=131 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64708 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter and save result | Excel Discussion (Misc queries) | |||
| Filter and save result | New Users to Excel | |||
| I want result of a function in the cell and not the function itsel | Excel Worksheet Functions | |||
| Value or function as result.... | Excel Worksheet Functions | |||
| function based on result of same function | Excel Discussion (Misc queries) | |||
Threaded Mode
