# If statements

#### mellie49

##### New Member
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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
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

Replies
1
Views
196
Replies
2
Views
309
Replies
17
Views
645
Replies
22
Views
619
Legacy 143009
L
Replies
4
Views
295

1,211,881
Messages
6,104,552
Members
447,915
Latest member
jpearson

### 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.

### Which adblocker are you using?

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

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