If And formulas

[mikeywhits]

Hi all,

I am trying to do the following...

cell A1 = 16/06/11, cell B1 = 33.

If A1 is todays date or has past this date, and B1 is less than 33 then True

Look forward to your responses.

Mike

 

[VoG]

Try

=AND(A1<=TODAY(),B1<33)

 

[T. Valko]

Hi all,

I am trying to do the following...

cell A1 = 16/06/11, cell B1 = 33.

If A1 is todays date or has past this date, and B1 is less than 33 then True

Look forward to your responses.

Mike

Try this...

=AND(N(A1)>=TODAY(),N(B1)<33)

 

[mikeywhits]

Thanks guys, both work great

 

[Desu Nota from Columbus]

Try this...

=AND(N(A1)>=TODAY(),N(B1)<33)

What is the purpose of the N before the cell reference?

 

[T. Valko]

Thanks guys, both work great

They both can't work because they do the opposite thing with regards to testing the date cell!

 

[T. Valko]

Try this...

=AND(N(A1)>=TODAY(),N(B1)<33)

What is the purpose of the N before the cell reference?

N makes sure there is in fact a numeric value entered in both cells.

 

[mikeywhits]

Hi VoG,

I am using your formula,=AND(A1<=TODAY(),B1<33), for less than 33, though how can i change this to greater than 32 and below 66???

Thanks.

Mike

 

[mikeywhits]

Hi Vog,

Finally I am trying to get the formula

cell A1 = 16/06/11, cell B1 = between 0 and 100.

If A1 is todays date or has past this date, and B1 is either...

greater than 0 and less than 33, if this is true then the cell where i am putting this formula shows the value "R".

greater than 33 and less than 66, if this is true then the cell where i am putting this formula shows the value "A".

greater than 65 and less than 100, if this is true then the cell where i am putting this formula shows the value "G".

I am not sure how possible this is???

Thanks,

Mike

 

[Desu Nota from Columbus]

=IF(AND(A1<=TODAY(),B1<33, B1>0),"R",IF(AND(A1<=TODAY(),B1>=33, B1<66),"A",IF(AND(A1<=TODAY(),B1>=66, B1<100),"G")))


You didn't specify your numbers very accurately.

What if B=33 or 66 or 100?

What if B>100?

What if B=0?


The above formula designates the following, check if this is what you want:
If B=33, A
If B=66, G