Posted to microsoft.public.excel.worksheet.functions
|
|
Please Help Again-Condition Formula
Thanks for you help!
"Rick Rothstein (MVP - VB)" wrote:
4) Put this formula in the second field (next to the Formula Is
drop-down)...
=AND(G11,H1="Day")
Note: Use "Daily" instead of "Day" if that is what you put in Column K
Damn! I forgot to change the column reference from my test case... the above
formula should have been this...
=AND(G11,K1="Day")
Sorry for any confusion that may have caused.
Rick
|