As ever, show us what you have got so far.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"DCM84 " wrote in message
...
Thanx bob, that worked great!

Only thing is, I realised now that i want to use another two IF
statements for the formula that i had 4got to include! Is it possible
to combine four IF statements together?

I tried using the same principal you gave me on the original two IF
statements but excel says i am missing a --) or a (.

Any ideas?

Thanx
DCM84


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