HI, Name - Harmeet Tip - Calculate formula using F9 Detail : Lets say you have a formula : =IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1)) in order to calculate partial formula you need to select desired formula like this: =IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1)) Then press F9, it will convert the formula to value. Then press Ctrl+Z to revert the change (If required)
Benefit - For long formulae user can verify the result for subformula of main formula. For explanation see attached screenshot......... On Tue, Jun 23, 2009 at 10:43 PM, Harmeet Singh <harmeet.hew...@gmail.com>wrote: > HI, > > Name - Harmeet > Tip - Calculate formula using F9 > Detail : > Lets say you have a formula : > =IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1)) > in order to calculate partial formula you need to select desired formula > like this: > =IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1)) > Then press F9, it will convert the formula to value. > Then press Ctrl+Z to revert the change (If required) > > Benefit - For long formulae user can verify the result for subformula of > main formula. > > For explanation see attached screenshot......... > > > > > On Sun, Jun 21, 2009 at 8:49 PM, Ayush <jainayus...@gmail.com> wrote: > >> >> Dear Members, >> >> Thanks for your great response in the Week 25 competition. It was >> again great learning for the members of the group. >> Let us begin week # 26 quiz with the more spirit. This is last chance >> for you to be eligible for June month competition.The winner of week # >> 25 will be declared soon. Keep watching this Space...... >> >> Last Date of Submission of tips : 28th June 2009. >> >> PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE >> CONSIDERED FOR PRIZES. >> DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS. >> >> You need to submit your name, Subject & the details of tips and >> tricks. >> DO let me know if you need any clarifications. >> >> Let me begin by submitting the first tip for this week competition. >> >> --------------------------------------------------------------------------------------------------------------------------------------------------- >> Name : Ayush Jain >> Subject : Format Painter >> Detail : The little "format painter" is the most useful button in >> Excel. It looks like a paintbrush and is grouped with the >> cut,copy,paste buttons. Basically highlight a cell with the formating >> that you want, click the button, and then highlight cell(s) that you >> want to just paste the format. HUGE time saver! >> >> Who is next ???????????????????? >> >> > > > -- > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > > > -- Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<attachment: tip2.png>>
