+ Reply to Thread
Results 1 to 3 of 3

How to create a formula to show sum?

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    How to create a formula to show sum?

    I have to calculate the member fee plus the member discount. I am given the member discount which is in C7 and the non member fee which is in d7 and the total weeks in b7 how do i calculate the member fee with the fee discount from this? the member fee and the discount will be posted in E7.
    Attached Files Attached Files
    Last edited by jolyim; 09-29-2012 at 03:02 PM.

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: How to create a formula to show sum?

    Maybe...
    In E7
    =D7-(C7*D7)

    In H7
    =(F7*D7)+(G7*E7)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    09-29-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: How to create a formula to show sum?

    Thank You so much I was completley lost on how to formulate this !!! @Ace_XL

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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