Formula mismatch in Excel 2003 & 2007
in [Functions]
|
From: Terence D'Souza Terence on 17 Dec 2009 00:21 A formula written (combination of datedif & vlookup) in Excel 2003 does not show the same value when opened in Excel 2007. This is a salary calculation where based on Date of Joining. Yearly increment is due as per date of Joining Suppose the Date of Joining is 10th of Dec The intent is to pay 9 days on the previous increment & 23 days on the new increment. Excel 2003 shows the correct outcome.
From: T. Valko on 17 Dec 2009 00:38 There is a bug in DATEDIF when used in Excel 2007 with service pack 2. -- Biff Microsoft Excel MVP "Terence D'Souza" <Terence D'Souza(a)discussions.microsoft.com> wrote in message news:A75165A0-1399-4257-BDD6-EE3DA50C2FF8(a)microsoft.com... >A formula written (combination of datedif & vlookup) in Excel 2003 does not > show the same value when opened in Excel 2007. > This is a salary calculation where based on Date of Joining. > Yearly increment is due as per date of Joining > Suppose the Date of Joining is 10th of Dec > The intent is to pay 9 days on the previous increment & 23 days on the new > increment. > Excel 2003 shows the correct outcome.
From: Ashish Mathur on 19 Dec 2009 07:27 Hi, Psot the exact dates, your datedif formula and the expected answer -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Terence D'Souza" <Terence D'Souza(a)discussions.microsoft.com> wrote in message news:A75165A0-1399-4257-BDD6-EE3DA50C2FF8(a)microsoft.com... > A formula written (combination of datedif & vlookup) in Excel 2003 does > not > show the same value when opened in Excel 2007. > This is a salary calculation where based on Date of Joining. > Yearly increment is due as per date of Joining > Suppose the Date of Joining is 10th of Dec > The intent is to pay 9 days on the previous increment & 23 days on the new > increment. > Excel 2003 shows the correct outcome.
|
Pages: 1 Prev: How do I insert a check box in Excel Vista? I'm a novice Next: Q on LARGE function |