Results 1 to 6 of 6

Thread: Integration Formulas & International Options

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 01-03-2013, 07:43 PM #1
    PcMax
    PcMax is offline
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    15
    Hi,

    Formula to convert:
    =IF(AND($C4<>"",OR(MONTH($C4)=1,MONTH(EDATE($C4,1) )=1,MONTH(EDATE($C4,2))=1)),VLOOKUP($D4,$R$4:$S$5, 2,FALSE),"")
    En.excel-translator.de:
    =SE(E($C4<>"";O(MESE($C4)=1;MESE(DATA.MESE($C4;1)) =1;MESE(DATA.MESE($C4;2))=1));CERCA.VERT($D4;$R$4: $S$5;2;FALSO);"")
    Perfect! I recommend it to everyone.
    Reply With Quote Reply With Quote
  2. 01-04-2013, 01:54 AM #2
    rollis13
    rollis13 is offline
    Member rollis13's Avatar
    Join Date
    Nov 2012
    Posts
    36
    Rep Power
    0
    Quote Originally Posted by PcMax View Post
    [...]Perfect! I recommend it to everyone.
    That's what I thought I said in post #2 .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Custom Data Validation :: Using Formulas
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-04-2013, 05:40 PM
  2. formulas needed please
    By paul_pearson in forum Excel Help
    Replies: 5
    Last Post: 03-21-2013, 04:43 PM
  3. Copying formulas while keeping formating
    By Bradh in forum Excel Help
    Replies: 1
    Last Post: 12-02-2012, 11:32 AM
  4. Excel and Outlook Integration For email sending with signature file
    By Data_Analyst in forum Excel Help
    Replies: 3
    Last Post: 02-20-2012, 12:54 AM
  5. Dependent Data Validation (Using Only Formulas)
    By Admin in forum Download Center
    Replies: 2
    Last Post: 10-18-2011, 03:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules