J
joseph.mccastlain
Hi,
I am trying to populate a table based upon revenue from a closed
project. I need the revenue to be divided by the number of quarters
in a year and have that revenue populate the apporpriate cell.
Furthermore, the formula needs to determine which quarters based upon
the closing date. Using the data below, the first project would need
to have the revenue of $20,000 divided by the four quarters of the 12
months of the contract. So it would need to reflect $5000 across the
four quarters. I can use an IF statement but the main problem with
that is when I evaluate multiple quarters within the range of the
close date.
close date Revenue contract length in months
1/31/2007 20,000 12
1/1/2007 40,000 60
Any help is appeciated!
I am trying to populate a table based upon revenue from a closed
project. I need the revenue to be divided by the number of quarters
in a year and have that revenue populate the apporpriate cell.
Furthermore, the formula needs to determine which quarters based upon
the closing date. Using the data below, the first project would need
to have the revenue of $20,000 divided by the four quarters of the 12
months of the contract. So it would need to reflect $5000 across the
four quarters. I can use an IF statement but the main problem with
that is when I evaluate multiple quarters within the range of the
close date.
close date Revenue contract length in months
1/31/2007 20,000 12
1/1/2007 40,000 60
Any help is appeciated!