With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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