Calculating using a date
Not real sure I understand your conditions, but give this a try...
=IF(B2=2,"",IF(AND(DAY(A2)27,B2<2),B2,C2))
Vaya con Dios,
Chuck, CABGx3
"Dianethetech" wrote:
That solves one problem, now I need to know how I can say
=If(DAY(A2)27,B2,C2)AND B2 IS < 2 THEN B2 IF NOT MAKE IT BLANK
DMM
"CLR" wrote:
Try this...........
=If(DAY(A2)27,B2,C2)
Vaya con Dios,
Chuck, CABGx3
"Diane" wrote:
I am trying to write an if statement to grab a certain cell if a date is 5
and the # in cell e2 is <4. I am having trouble getting the date.
A B C
4/28/06 64 1
This is what I wrote, but it's not capturing the date the correct way.
If(A227,B2,C2)
Thanks in advance of any help anyone can give me.
|