+ Reply to Thread
Results 1 to 2 of 2

Calculation of Column Based on Month

  1. #1
    Registered User
    Join Date
    01-24-2008
    Posts
    13

    Calculation of Column Based on Month

    Hi I have a spreadsheet spread over with dates in column A from September to December and I have a fuel rebate column as well. The fuel rebate is different for each month and is calculated as a certain amount of cents per dollar added to the total amount in Column B

    September: 26c
    October: 13.5c
    November: 43c
    December: 66c
    e.g. If there is an invoice for 10/9/07 (september) for $100, then the fuel rebate would be $100*.26 which equals $26 fuel rebate.

    I want to calculate from column B (this is the column with the dollar amount in it), but I want the calculation to be different depending on what date is in column A, so if in column A the dated month is October, then the calculation would be something like B2*0.135.

    Can someone give me the calculation I am certain you don't need VBA for this right (just nested IF statements?)

    This is the example of the spreadsheet how I would like it to behave

    Date: Net: Fuel Rebate:
    1/10/07 $100 $13.50
    15/10/07 $100 $13.50
    19/10/07 $100 $13.50
    25/11/07 $100 $43
    28/11/07 $100 $43
    5/12/07 $100 $66
    Last edited by Kostanzas200; 02-27-2008 at 09:26 PM.

  2. #2
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103
    you need a table if your fuel rebate.

    i.e. in cells F1 through G6 put:
    10 .26
    11 .13
    12 .45
    1 .33
    2 .18

    Or whatever the actual values are

    then in cell C2 down your formula is:

    =vlookup(month(a2),$F$1:$G$6,2,false)*b2

+ 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