Sleeper: If and Statement based on one cell and

[mark jones]

AussieBear,

thanks for the reply. i have attached the workbook.