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.
|