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

 

[T. Valko]

=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

If you need to repeatedly use a volatile function throughout a formula it's better to use a cell to hold that value then refer to the cell:

X1 = =TODAY()

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