Tobit- I don't mean to be a pain, or stonewall you, but this is one of
those "teach a man to fish" situations. If I give you the answer
you'll have it, but next time you won't know what to do. So- please
use the Help function (F1 in Excel) and review the IF function. It's
very straightforward, and easily applied to your requirements.