Completed

Excel (2010) formula for retail pricing (rounding). See details.

I need a retail pricing formula that will take a number, like 7.45 ($7.45) and round it up to the nearest .09. [example: $7.49). BUT....anything below 7.20 would be rounded down to $6.99, etc.

Also, I should be able to change the formula slightly, if needed, to .07 or .95. And be able to change the round down point (example: instead of below 7.20 to below 7.14.

Skills: Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic

See more: match formula excel 2010, excel 2010 formula delete, formula distance calculation excel 2010, formula tier pricing excel, excel free formula document, excel conditional formula, excel repayment formula, excel mortgage formula, excel rate formula php, excel paid formula, day excel payment formula, rank excel vba formula, excel making formula, excel ranking formula, excel morgage formula

About the Employer:
( 761 reviews ) Woburn, United States

Project ID: #16720747

Awarded to:

katiewells3

Hi there, what you are after sounds simple enough - I would suggest nominating three cells in the work sheet 1. for the rounding point (i.e. above / below 20 cents in your example) one for the round down amount (so whe More

$25 USD in 1 day
(19 Reviews)
4.7

20 freelancers are bidding on average $23 for this job

cgullapalli

Hi, I am good at Excel formula (Rounding formulas). Please share the file. I will work on the problem and provide the solution asap. -Chandra

$15 USD in 0 days
(679 Reviews)
7.7
priyal1997

Hi There, Just send me the file. First I will do this task for you, and if you are done, later you can offer me the job. I'm an expert in advanced excel formulas, and have already done lots of similar works. You may More

$15 USD in 0 days
(185 Reviews)
6.7
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel More

$30 USD in 1 day
(29 Reviews)
5.7
sarcscoin

Hi, I can provide round formulas and it is easy for you to modify as required. Can you please send me the file across chat. I can start working on it. -Sri

$10 USD in 0 days
(54 Reviews)
4.6
humayoonsheikh4u

Dear Sir, I am an excel professional having hands on expertise in developing spreadsheet for analytical purpose I will do your project as per your requirements by applying advanced excel formulas like if statement wi More

$30 USD in 1 day
(10 Reviews)
4.1
INFINITYADVERT

I can make a creative and professional logo design. I have 9 years of experience in I have made several types of designs. He first draft will be in just 24 hours. Tanks

$25 USD in 0 days
(4 Reviews)
3.6
MaryumAkhter1

Email address and contact detail extraction from web- Web data collection- Plain data entry- JPG/PDF to DOC file- Entry in Excel. Data Transcription- Conversion – Processing – Typing – File Conversion the further deta More

$28 USD in 1 day
(2 Reviews)
1.7
Hasnain323429

I am expert in this field....... your satisfaction is my priority.... lets see more in chat.......................

$10 USD in 1 day
(1 Review)
0.9
$30 USD in 1 day
(0 Reviews)
0.0
DEEPAKYPATIL

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
kshirley94

Expert in excel. Engaged with microsoft ecel with more than 5 years. Quality as promised. Relevant Skills and Experience Excel

$30 USD in 2 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
tanushreekalita

I have read the job description very carefully and have understood the project scope . I have a very good experience doing this kind of job. If you wish I can send a sample for your review. I hope sample will prove More

$25 USD in 1 day
(0 Reviews)
0.0
pajemarikris

When you hire me I will do all my best to give you your expectations to me as your worker Relevant Skills and Experience I am graduated ms office productivity tools course in our barangay. I recently work as an encode More

$25 USD in 1 day
(0 Reviews)
0.0
neritanzylyftari

Hi, i can evade your request in 24 [login to view URL] me If you need any additional information. Thnx Neritan Zylyftari

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
cheukokhoong

I am experienced excel user and should be able to help you out. As of time of posting, I'm available to take up this job. Kindly inform me about the task, timeline and budget. Thank you

$25 USD in 1 day
(0 Reviews)
0.0
SERVIQINTER

Hello, I have an experience who work those kind of project. please come on chat so we can discuss more about the project. Thank you.

$20 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0