Making a Tricky formula even trickier!

[Duncan]

Hi all,

Following up from a previous thread of mine:

http://groups.google.co.uk/group/mi...9a059?lnk=st&q=&rnum=1&hl=en#bab701b2bb49a059


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

 

[Duncan]

Hi All,

I have been trying and trying for ages now to work this out on my own,
still cant get it, is anyone out there who can help?

Many thanks

Duncan