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/