Hi all,

Following up from a previous thread of mine:

http://groups.google.co.uk/group/mic...01b2bb 49a059


Now I need to add an extra condition!

I need the formula to look at one more cell, lets say the cell is J5,
now if there is nothing in column C, and there is a date in either B or
A, and the cell J5 has something beginning with an "N", then the result
needs to be "0".

Is this possible? anyone with a good mind for formulas please please
help, it makes so much sense if you look at the thread above and see
the original formula I need to amend.

Many thanks in advance

Duncan