If statements

mellie49

New Member
Joined
Oct 3, 2006
Messages
1
Hi,

I have a user input a $ value for a project. The next cell over I have a validation drop down cell for the user to select a year the project will be installed. I want the next cells to divide the cost of the project based on what year it should be installed. But it should be flexible so that if the user changes the year, the cash flow can change again to flow through different years.

For example: User enter in cost of $100 and 2008.

I want excel to fill the 2008 column with $50 and 2009 column with $50.

Currently I just have an IF statement to get $100 into the 2008 column. How do I make it so excel can divide equally across several years.
=IF(H4="2008 Q1", F4/4, "") Is there an If... Then statement that can be used?

Any help is much appreciated!
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
You might be sorry you asked, but here goes

In J13

=IF($G13>0,($G13/(1+$I13-$H13))*(IF((K$9-J$9-IF(K$9-1>$I13,K$9-1-$I13,0)-IF($H13>J$9,$H13-J$9,0))>0,(K$9-J$9-IF(K$9-1>$I13,K$9-1-$I13,0)-IF($H13>J$9,$H13-J$9,0)),0)),0)


where,

J9:BJ9 is a timescale (days, weeks, months - doesnt matter)

G13 is the value to be distributed

H13 is the start date for the distribution
I13 is the end date for the distribution


HTH
 

Forum statistics

Threads
1,136,423
Messages
5,675,765
Members
419,585
Latest member
popsin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top