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

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


Duncan wrote:
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