T
T_Sr via OfficeKB.com
I get paid on the 1st and 15th of every month unless that day falls on a
weekend or holiday. If that happens I get paid on the business day prior to
the 1st or 15th. I have a flash that pops up on paydays by nesting the IF
function:
(=(IF(AND(B200=2,C200=15),"P * A * Y * D * A * Y",IF(AND(B201=3,
C201=1),"P * A * Y * D * A * Y",IF(AND(B202=3,C202=15),"P * A *
Y * D * A * Y",IF(AND(B203=3,C202=30),"P * A * Y * D * A * Y",
IF(AND(B204=4,C204=13),"P * A * Y * D * A * Y",IF(AND(B205=5,C205=1)
,"P * A * Y * D * A * Y",IF(AND(B206=5,C206=15),"P * A * Y *
D * A * Y","")))))))).
*B200 through B206= the number for the month of the year, and C200 through
C206= the day of the month that is actually payday.
I can only nest 7 of these and get tired of having to go through and put in
the new dates for paydays to keep the flash popping up. Is there anything
that could possibly do this for me. I know nothing about macros and am
trying to learn how they work. Any help is greatly appreciated.
Travis Sr.
--
Thanks,
T_Sr
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-new/200702/1
weekend or holiday. If that happens I get paid on the business day prior to
the 1st or 15th. I have a flash that pops up on paydays by nesting the IF
function:
(=(IF(AND(B200=2,C200=15),"P * A * Y * D * A * Y",IF(AND(B201=3,
C201=1),"P * A * Y * D * A * Y",IF(AND(B202=3,C202=15),"P * A *
Y * D * A * Y",IF(AND(B203=3,C202=30),"P * A * Y * D * A * Y",
IF(AND(B204=4,C204=13),"P * A * Y * D * A * Y",IF(AND(B205=5,C205=1)
,"P * A * Y * D * A * Y",IF(AND(B206=5,C206=15),"P * A * Y *
D * A * Y","")))))))).
*B200 through B206= the number for the month of the year, and C200 through
C206= the day of the month that is actually payday.
I can only nest 7 of these and get tired of having to go through and put in
the new dates for paydays to keep the flash popping up. Is there anything
that could possibly do this for me. I know nothing about macros and am
trying to learn how they work. Any help is greatly appreciated.
Travis Sr.
--
Thanks,
T_Sr
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-new/200702/1