View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Duncan[_5_] Duncan[_5_] is offline
external usenet poster
 
Posts: 290
Default Re-Post - hard formula (Bob Phillips out there anywhere?...)

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