Formula in Excel

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!
cansevinAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ronnel dela LuzConnect With a Mentor AnalystCommented:
D2=(9-C2)+2015
0
 
X_layerCommented:
Or in D2 put:
=2024-C2

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.