LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Formula Help... To Hard for me!!! LOL j5b9721 Excel Discussion (Misc queries) 4 September 16th 07 05:36 PM
Attn: Bob Phillips (or any expert!)... help with formula Toppers Excel Worksheet Functions 7 July 26th 07 07:16 PM
inserting hard CR in a formula Rick Morrison Excel Worksheet Functions 1 November 8th 06 04:51 PM
Hard returns in a formula? PCLIVE Excel Worksheet Functions 5 February 8th 06 05:17 PM
Date Conversion Formula from Bob Phillips... Petra[_2_] Excel Programming 0 July 30th 04 08:45 PM


All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"