Hopefully someone can help me with this or at least point me in the right direction.
I am trying to comeup with a formula that will look at a number of options befor outputting the desired answer.
I have attached a spreadsheet which explains is a lot better than i just did,
but the output column is where i need the formula
Cheers
Joe
Bookmarks