Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving A One Off IF Result
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 A5 matches 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. -- Thanks Becky |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving A One Off IF Result
You would need VBA code to do that, would you be comfortable with that?##Rebecca;231282 Wrote: 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 A5 matches 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. -- Thanks Becky -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64614 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving A One Off IF Result
-- Thanks Becky "Simon Lloyd" wrote: You would need VBA code to do that, would you be comfortable with that?##Rebecca;231282 Wrote: Hi Simon, Being new at excel, I have not ventured into VBA as of yet but I am always willing to have a go. If I give you the simple IF formula that I have entered in c5 being:- =IF(a5=e5,b5) would you be willing to tell me what to do or is it to complicated that really I should go and learn about VBA first. Becky. 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 A5 matches 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. -- Thanks Becky -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64614 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving A One Off IF Result
Becky, if you want, join the forum below (it's free) where i can take you through a series of examples and workbooks so that you understand what is happening, can follow it and then maybe adapt it for future use, if you are new to VBA you will need some guidance whether it be here or anywhere else, all the folk that can do VBA are STILL learning! ;) Rebecca;231485 Wrote: -- Thanks Becky "Simon Lloyd" wrote: You would need VBA code to do that, would you be comfortable with that?##Rebecca;231282 Wrote: Hi Simon, Being new at excel, I have not ventured into VBA as of yet but I am always willing to have a go. If I give you the simple IF formula that I have entered in c5 being:- =IF(a5=e5,b5) would you be willing to tell me what to do or is it to complicated that really I should go and learn about VBA first. Becky. 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 A5 matches 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. -- Thanks Becky -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' ('The Code Cage' (http://www.thecodecage.com)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'Saving A One Off IF Result - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=64614) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64614 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions |