Simple formula
I **hate** the Ctrl+Enter short-cut that physically sends the message in
Windows Mail (and Outlook Express)! Let's try it again.
It's Sunday... things are slow... I'm bored... so to be different...
=RIGHT("Not Tested",6*(B5="Yes")+10*(B5="No"))
Rick
|