D
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
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