Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function with date
This seems really basic, but I looked and looked and couldn't find an
answer.... A B C Date Wage OT Calc 2/1/2000 $7.50 1/1/2000 $8.00 In column C, I want the calculation to take the wage and double it, if the date in A1 is on or after 2/1/2000. Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function with date
Hi!
A couple of things: 1/1/2000 That's obviously Jan 1 2000. if the date in A1 is on or after 2/1/2000 Is that Jan 2 2000 or Feb 1 2000 ? Also, based on your little table wouldn't that date be in A2? Try this: =IF(AND(COUNT(A2:B2)=2,A2=DATE(2000,?,?)),B2*2,"" ) Replace the ?'s with the month and day. Biff "Christina" wrote in message ... This seems really basic, but I looked and looked and couldn't find an answer.... A B C Date Wage OT Calc 2/1/2000 $7.50 1/1/2000 $8.00 In column C, I want the calculation to take the wage and double it, if the date in A1 is on or after 2/1/2000. Thanks in advance! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function with date
Thank you very much. Just a follow up question and some clarification. Yep,
you're right, the first actual date would have been in cell A2. And, the format I'm using is m/d/yyyy. So, your function works, but I'm a little confused about why I need the COUNT function? If I just use =IF(A2=DATE(2000,2,1)),B2*2,"") rather than =IF(AND(COUNT(A2:B2)=2,A2=DATE(2000,?,?)),B2*2,"" ) it seems to work. What am I missing? _c "Biff" wrote: Hi! A couple of things: 1/1/2000 That's obviously Jan 1 2000. if the date in A1 is on or after 2/1/2000 Is that Jan 2 2000 or Feb 1 2000 ? Also, based on your little table wouldn't that date be in A2? Try this: =IF(AND(COUNT(A2:B2)=2,A2=DATE(2000,?,?)),B2*2,"" ) Replace the ?'s with the month and day. Biff "Christina" wrote in message ... This seems really basic, but I looked and looked and couldn't find an answer.... A B C Date Wage OT Calc 2/1/2000 $7.50 1/1/2000 $8.00 In column C, I want the calculation to take the wage and double it, if the date in A1 is on or after 2/1/2000. Thanks in advance! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function with date
The Count function is just to make sure that both a true Excel date and a
wage value have been entered. That way, the formula cell doesn't display an intermediate incorrect result. For example, without the Count function, if you enter a date that meets the criteria before you enter a wage the formula would return 0 until you also enter the wage. With the Count function the formula cell remains blank until both values have been entered. Biff "Christina" wrote in message ... Thank you very much. Just a follow up question and some clarification. Yep, you're right, the first actual date would have been in cell A2. And, the format I'm using is m/d/yyyy. So, your function works, but I'm a little confused about why I need the COUNT function? If I just use =IF(A2=DATE(2000,2,1)),B2*2,"") rather than =IF(AND(COUNT(A2:B2)=2,A2=DATE(2000,?,?)),B2*2,"" ) it seems to work. What am I missing? _c "Biff" wrote: Hi! A couple of things: 1/1/2000 That's obviously Jan 1 2000. if the date in A1 is on or after 2/1/2000 Is that Jan 2 2000 or Feb 1 2000 ? Also, based on your little table wouldn't that date be in A2? Try this: =IF(AND(COUNT(A2:B2)=2,A2=DATE(2000,?,?)),B2*2,"" ) Replace the ?'s with the month and day. Biff "Christina" wrote in message ... This seems really basic, but I looked and looked and couldn't find an answer.... A B C Date Wage OT Calc 2/1/2000 $7.50 1/1/2000 $8.00 In column C, I want the calculation to take the wage and double it, if the date in A1 is on or after 2/1/2000. Thanks in advance! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function with date
You are clearly smarter than I ! Thanks for explaining, I definitely get it
now! _c "Biff" wrote: The Count function is just to make sure that both a true Excel date and a wage value have been entered. That way, the formula cell doesn't display an intermediate incorrect result. For example, without the Count function, if you enter a date that meets the criteria before you enter a wage the formula would return 0 until you also enter the wage. With the Count function the formula cell remains blank until both values have been entered. Biff "Christina" wrote in message ... Thank you very much. Just a follow up question and some clarification. Yep, you're right, the first actual date would have been in cell A2. And, the format I'm using is m/d/yyyy. So, your function works, but I'm a little confused about why I need the COUNT function? If I just use =IF(A2=DATE(2000,2,1)),B2*2,"") rather than =IF(AND(COUNT(A2:B2)=2,A2=DATE(2000,?,?)),B2*2,"" ) it seems to work. What am I missing? _c "Biff" wrote: Hi! A couple of things: 1/1/2000 That's obviously Jan 1 2000. if the date in A1 is on or after 2/1/2000 Is that Jan 2 2000 or Feb 1 2000 ? Also, based on your little table wouldn't that date be in A2? Try this: =IF(AND(COUNT(A2:B2)=2,A2=DATE(2000,?,?)),B2*2,"" ) Replace the ?'s with the month and day. Biff "Christina" wrote in message ... This seems really basic, but I looked and looked and couldn't find an answer.... A B C Date Wage OT Calc 2/1/2000 $7.50 1/1/2000 $8.00 In column C, I want the calculation to take the wage and double it, if the date in A1 is on or after 2/1/2000. Thanks in advance! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function with date
You're welcome. Thanks for the feedback!
Biff "Christina" wrote in message ... You are clearly smarter than I ! Thanks for explaining, I definitely get it now! _c "Biff" wrote: The Count function is just to make sure that both a true Excel date and a wage value have been entered. That way, the formula cell doesn't display an intermediate incorrect result. For example, without the Count function, if you enter a date that meets the criteria before you enter a wage the formula would return 0 until you also enter the wage. With the Count function the formula cell remains blank until both values have been entered. Biff "Christina" wrote in message ... Thank you very much. Just a follow up question and some clarification. Yep, you're right, the first actual date would have been in cell A2. And, the format I'm using is m/d/yyyy. So, your function works, but I'm a little confused about why I need the COUNT function? If I just use =IF(A2=DATE(2000,2,1)),B2*2,"") rather than =IF(AND(COUNT(A2:B2)=2,A2=DATE(2000,?,?)),B2*2,"" ) it seems to work. What am I missing? _c "Biff" wrote: Hi! A couple of things: 1/1/2000 That's obviously Jan 1 2000. if the date in A1 is on or after 2/1/2000 Is that Jan 2 2000 or Feb 1 2000 ? Also, based on your little table wouldn't that date be in A2? Try this: =IF(AND(COUNT(A2:B2)=2,A2=DATE(2000,?,?)),B2*2,"" ) Replace the ?'s with the month and day. Biff "Christina" wrote in message ... This seems really basic, but I looked and looked and couldn't find an answer.... A B C Date Wage OT Calc 2/1/2000 $7.50 1/1/2000 $8.00 In column C, I want the calculation to take the wage and double it, if the date in A1 is on or after 2/1/2000. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date function in Excel that updates only when a doc is changed? | Excel Worksheet Functions | |||
Date Function | Excel Discussion (Misc queries) | |||
date format and the RIGHT function | Excel Worksheet Functions | |||
Date function | Excel Worksheet Functions | |||
Is there a function to show future date | Excel Worksheet Functions |