Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex If/Or/And formula
I am working on a formula that has me frazzled. I can't get seem to get the
correct result for all of my scenarios. Column G is Planned End Date Column H is Revised End Date This is what I have so far; =OR(ISBLANK(G3),(WORKDAY(NOW(),0)-WORKDAY(G3,0)<7),OR((WORKDAY(H3,0)<WORKDAY(NOW(),0 )),ISBLANK(H3))) I am going to use the formula in a Conditional Formatting for Column G If any of the "tests" are true, I will color the cell Red. IF G3 is Blank TRUE IF G3 < 7 days from NOW() and H3 is Blank TRUE IF G3 < 7 days from NOW() and H3 < NOW() TRUE --- news://freenews.netfront.net/ - complaints: --- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex IF formula | Excel Worksheet Functions | |||
complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
complex formula? | Excel Discussion (Misc queries) | |||
Complex formula | Excel Worksheet Functions | |||
Complex Formula | Excel Worksheet Functions |