Results 1 to 6 of 6

Need formula to calculate redeemed points from above date and month

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Need formula to calculate redeemed points from above date and month

    Dear experts

    I have some range data column wise date and month nos i want calculate redeemed points of month.

    month nos like 3,6,12,24,36 i want find how many times of 24 & 36 if its first time 5 points *month,for second time 6 points*month if come more than twice i want give 12 points * Month, till end of column right.rest of ,3,6,12 no points.

    find the attachment i want formula in where ever find redeemed value
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula To Calculate Hours Completed Month To Date
    By rahul_ferns76 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2016, 10:46 AM
  2. Need a formula to calculate running anticipated total for a Month to Date report
    By GreyedOutJedi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2016, 06:02 PM
  3. Calculate Points Based On Higher Date
    By kwood41799 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2015, 05:21 PM
  4. [SOLVED] Calculate Points Based On Higher Date
    By kwood41799 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-24-2015, 10:52 AM
  5. Replies: 4
    Last Post: 01-14-2014, 03:50 PM
  6. Formula to calculate a month before a renewal date is due to expire
    By Charlene C in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2013, 11:49 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1