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
Bookmarks