Statement
 

I would like a statement to show up if a limit has exceeded after a certain
date. For discussion purposes,

Date Quantity
1/1/04 100
2/1/04 100
3/1/04 150
6/5/04 105
7/5/04 103
8/5/04 105

If any quantity exceeds 100 after 7/1/04, I would like to show a statement
stating "Limit has exceeded." otherwise no statement will show up.

You can copy down somehting like

=IF(AND(A2=DATE(2004,7,1),B2100),"Limit has exceeded","")


Regards,

Peo Sjoblom


"lintan" wrote:

I would like a statement to show up if a limit has exceeded after a certain
date. For discussion purposes,

Date Quantity
1/1/04 100
2/1/04 100
3/1/04 150
6/5/04 105
7/5/04 103
8/5/04 105

If any quantity exceeds 100 after 7/1/04, I would like to show a statement
stating "Limit has exceeded." otherwise no statement will show up.