That's great. Works fine. Just to take it one step further, How do
display Nothing in the formula box if the D5 cell contains anythin
other than "B" or "S"?

At the moment, it will display Loss if anything other than B or S is i
cell D5

Appreciate the hel

--
Message posted from http://www.ExcelForum.com