IF FORMULA
in [General]
|
Prev: formula needs to move across 1 column every week
Next: .xls .doc files have become corrupted after BSOD!!! how recover?
From: Donna on 5 Apr 2010 23:43 Hi: I am trying to write an if formula that if B2 is equal to a specific date in a range of dates then it is the end of a pay period, if B2 is equal to a date in a second range of dates then it state pay day. I have set up two tables with dates. One has pay period ending dates and the other table has pay day dates. I keep getting a Value error. Please help. -- Donna
From: ozgrid.com on 5 Apr 2010 23:59 =IF(COUNTIF(A1:A10,B2),"end of pay period",IF(COUNTIF(C1:C10,B2),"pay day","")) Change ranges to suit. -- Regards Dave Hawley www.ozgrid.com "Donna" <Donna(a)discussions.microsoft.com> wrote in message news:F417D8E0-D205-4C2B-9A12-0E2EBD65A00B(a)microsoft.com... > Hi: > > I am trying to write an if formula that if B2 is equal to a specific date > in > a range of dates then it is the end of a pay period, if B2 is equal to a > date > in a second range of dates then it state pay day. > > I have set up two tables with dates. One has pay period ending dates and > the > other table has pay day dates. > > I keep getting a Value error. > > Please help. > -- > Donna
From: Donna on 6 Apr 2010 00:09
Thank you so much!! -- Donna "Donna" wrote: > Hi: > > I am trying to write an if formula that if B2 is equal to a specific date in > a range of dates then it is the end of a pay period, if B2 is equal to a date > in a second range of dates then it state pay day. > > I have set up two tables with dates. One has pay period ending dates and the > other table has pay day dates. > > I keep getting a Value error. > > Please help. > -- > Donna |