176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Simple Excel formula writing needed
Sign in to Add to Watch List

Admin Support > Other - Administrative Support

View Change History

The client has made the following changes to the job.

Description
Date

Job canceled.

Oct 5, 2011

Job awarded.

Oct 5, 2011

Job awarded.

Oct 5, 2011
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Oct 05, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Hourly Rate: Less than $10 / hr
  • Hrs/wk: 1 | Duration: 1-2 weeks
  • Work View™ Payment Protection
  • W9 Not Required
Sign in to view client's details

I would like you to create a simple formula for me that would work in Excel 2007 to do the following:

I have a column with a drop-down list saying weekly, fortnightly, monthly, quarterly and annually. Immediately in front of this I have a costs cell and following this, I have an annual total cell.

What I need is a formula I can post into the annual total cell to say that If D5=monthly, then annual total =C5x12, if D5=weekly, then annual total=C5x52, if D5=fortnightly, then annual total=C5x26, if D5=quarterly, then annual total =C5x4, if D5=annually, then annual total =C5.

I need this done fairly quickly and would be willing to pay $10 for the formula that I could cut and paste into my document.

Sign in or Register to see more

Desired Skills
Microsoft Excel
Job ID: 26456617
Proposals
Hourly Rate: Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Australia  |  
Over 15 years experience as Data Management Specialist, equip with excellence data gathering technique, data manipulation, data reporting and great...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 26458015  |  Submitted: Oct 5, 2011 07:27 ET 
Proposal SEALED

 India  |  
GenNext Solutions, Hard working, accurate, on-time, and dedicated to work. Experienced in MS Office tools especially Excel, Word and Power Point....
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 26457840  |  Submitted: Oct 5, 2011 07:13 ET 
Proposal SEALED

 New Zealand  |  
Winner
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 26457811  |  Submitted: Oct 5, 2011 07:10 ET 
$8.77/hr

 United States  |  
I am a UNLV graduate with a Bachelor of Arts degree in Criminal Justice. I have several years of computer experience in retail and e-Commerce. I...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 26457475  |  Submitted: Oct 5, 2011 06:38 ET 
Proposal SEALED

 Pakistan
DETAIL ORIENTED SERVICE PROVIDERS, FAMILIAR WITH EXCEL, MS WORD, OUTLOOK EXPRESS, FAST TYPING, BASIC INTERNET RESEARCH, DATA ENTRY. ETC.,...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 26456990  |  Submitted: Oct 5, 2011 06:02 ET 
Proposal SEALED

K Y
 Malaysia  |  
I'm an Excel enthusiast and specialize in developing customized Excel solutions. My mixture of Excel/Programming (C#/Python)/Business/Finance...
1
  |  
 4.5   |  Private   |  1 Jobs
Bid ID: 26456981  |  Submitted: Oct 5, 2011 06:02 ET 
Proposal SEALED

Muzammil J.      
Muzammil J.'s identity has been verified.  Learn More
 Pakistan
The Company is strongly focus on customer satisfaction. we work in an efficient and cost effective fashion. our modest aim is to provide you...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 26456935  |  Submitted: Oct 5, 2011 05:59 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »