Excel: getting a formula to do a similar job as another

i would like the following formula (1) and (2) to work in the same way as formula (3) formula (3)

the above one return a value based on cell c9 on Agency Daily Input id like formula (2) to do the same
formula (3)

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of April 14, 2015.

For more resources for Microsoft Excel