Write a formula for recounting prices with random discounts
4 USD There is an export file with Prom in the Excel table. It is necessary to write a formula that accidentally generated a discount on the goods in the specified range (from 20 to 50%), added the amount of discount to the original value of the goods and recorded the discount itself in the specified column. In other words, it created the “sales effect”. For example:
The initial value of the goods is 200 grn, we generate a random discount (will it be 50%), we make the value of the goods 400 UAH and record in the columns with a discount value of 50%. It is also necessary to take into account in the formula rounding to "full". That is, the value of 195,50 or 218,30 is not permissible. Only with a round - 196 UAH or 218 UAH.
Client's review of cooperation with Anton D.
Write a formula for recounting prices with random discountsEverything is super. Excellent work in the shortest time.
Freelancer's review of cooperation with Aleksey Belgorodsky
Write a formula for recounting prices with random discountsThank you Alex for the clear task. It’s nice to work with adequate customers.
I recommend you UW. The freelancers.
-
1 day4 USD
1 day4 USD
Hello to you. Great experience in such tasks. Ready to perform in the best way. turn to
A systematic approach focused on your P&L and Cash Flow. I'd be glad to dive into your project details in private messages! -
Winning proposal1 day4 USD
755 72 0 Winning proposal1 day4 USDGood Morning Alex. Making a VBA macro. clear and correctly.
You can send the file. I do in the evening.
The experience!
-
1 day4 USD
2073 116 0 1 day4 USD
Good day ! I can write a program for processing your Excel file right now. I would also like to see an example of the file. Please call me, I'll be glad to help!
Current freelance projects in the category Databases & SQL
Database parsing
45 USD
Channel requirements: 1. Content language: Russian or Ukrainian (mixed RU/UA content is allowed) 2. Number of subscribers: At least 500 subscribers 3. Activity: The last post published no later than 32 hours ago 4. Comments: Comments must be open under the posts (through a group… Databases & SQL, Data Parsing ∙ 19 hours 44 minutes back ∙ 28 proposals |
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 3 days 22 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 4 days 16 hours back ∙ 10 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 5 days 9 hours back ∙ 92 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 5 days 12 hours back ∙ 18 proposals |
Izmail