Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula based steep date (2000 sr 1)

    Messaggio cancellato da sal21

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula based steep date (2000 sr 1)

    I'd create a small lookup table in Foglio2 and use that in a VLOOKUP formula. The formula in H2 is

    =IF(DATEDIF(J2,TODAY(),"m")<6,"",VLOOKUP(DATEDIF(J 2,TODAY(),"m"),Foglio2!$A$1:$B$5,2)*F2)

    and this can be filled down. See attached version.

Posting Permissions

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