# 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.

Beceriler: Veri Girişi, Veri İşleme, Excel, Microsoft Office, Visual Basic

İşveren Hakkında:
( 761 değerlendirme ) Woburn, United States

Proje NO: #16720747

## Seçilen:

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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(19 Değerlendirme)
4.7

## Bu iş için 20 freelancer ortalamada \$23 teklif veriyor

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

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(679 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(185 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(29 Değerlendirme)
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

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(10 Değerlendirme)
4.1

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

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
1.7
Hasnain323429

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.9
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
DEEPAKYPATIL

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
kshirley94

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
neritanzylyftari

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0