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.
Last edited by jolyim; 09-29-2012 at 03:02 PM.
Maybe...
In E7
=D7-(C7*D7)
In H7
=(F7*D7)+(G7*E7)
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank You so much I was completley lost on how to formulate this !!! @Ace_XL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks