+ Reply to Thread
Results 1 to 2 of 2

how do I calculate the Annual Membership cost and the Annual Total

Hybrid View

  1. 03-18-2015, 02:33 PM #1
    bellami
    bellami is offline
    Registered User
    Join Date
    03-17-2015
    Location
    ottawa
    MS-Off Ver
    office 2013
    Posts
    9

    how do I calculate the Annual Membership cost and the Annual Total

    I need help calculating the annual membership cost and the Annual Total, there is an attachment below
    thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-18-2015, 06:16 PM #2
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2505
    Posts
    2,790

    Re: how do I calculate the Annual Membership cost and the Annual Total

    Formula: copy to clipboard 
    =INDEX($C$26:$C$29,MATCH($C8,$B$26:$B$29,0))


    Formula: copy to clipboard 
    =INDEX($C$26:$C$29,MATCH($C8,$B$26:$B$29,0))+IF($E8="Yes",$D$31,0) + IF($F8="Yes",$D$32,0)


    Good Luck!!!
    Last edited by skywriter; 03-18-2015 at 06:18 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how do I calculate the annual membership cost and the Annual total
    By bellami in forum Excel General
    Replies: 1
    Last Post: 03-18-2015, 07:21 PM
  2. How do I calculate the Annual membership cost and the Annual total
    By bellami in forum Excel General
    Replies: 3
    Last Post: 03-17-2015, 11:36 PM
  3. Hoew do I calculate The Annually membership cost and The Annual totally?
    By bellami in forum Excel General
    Replies: 0
    Last Post: 03-17-2015, 06:16 PM
  4. Annual cost calculation based on changes.
    By sekharyadav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2013, 01:30 AM
  5. Annual Percentage Interest cost of discount not taken
    By Uli Hildebrand in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 12:50 AM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1