Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
tricky formula
Hi Guys,
been a while since ive been on here! I am trying to work out a tricky formula...I will attempt to paste an example below. Header1 Header2 Header3 Formula Values 1 Date Date 1 Date Date Date 1 Date Date 0 Date 0 Now if header 1 2 and 3 are blank then I want a result of 1 from my formula, if there are dates in all columns then I want a result of 1, and same if only B column is blank (or header2), but then if 3 is blank or 3 + 2 are blank then I want a result of 0. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky Formula | Excel Worksheet Functions | |||
Tricky Formula | Excel Discussion (Misc queries) | |||
Help with a tricky formula...... | Excel Discussion (Misc queries) | |||
Tricky formula | Excel Discussion (Misc queries) | |||
tricky formula.. please help | Excel Programming |