Thank you kindly to you both. That is indeed elegant.
If statements when eventually coded into programming gets tedious. Hence the aversion. A simple function is always elegant!

Pl have a look at a new post that I created, with the same subject that requires calculation. Any help is appreciated

http://www.excelforum.com/excel-form...75#post3404775