View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kareinia Kareinia is offline
external usenet poster
 
Posts: 10
Default 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