Solved

# Formula in Excel

Posted on 2011-09-27
247 Views
In column D, I need to create a formula that will be based on column C. The formula is if Column C says "9" then Column D needs to say "2015", if it says 10-column D says 2014, if it says 11- column D says 2013, if it says 12-column D says 2012.

The first cell is D2 to read what C2 says. If you can help that'd be awesome. Thanks!
0
Question by:cansevin

LVL 5

Accepted Solution

truinx earned 500 total points
D2=(9-C2)+2015
0

LVL 11

Expert Comment

Or in D2 put:
``````=2024-C2
``````
0

## Featured Post

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.