A dynamic discount calculator in Excel for Mac
- or -
Post a project like this1404
$$
- Posted:
- Proposals: 10
- Remote
- #2849695
- Awarded
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
IT Consultant |Virtual Assistant| graphics| | Website design | social media management .
Nairobi
14494331435881901141406416209896622911343873491423044342694844284115
Description
Experience Level: Intermediate
I hope this finds you well!
I'd like to be able to create a dynamic discount calculator in Excel for Mac. Firstly, do you work with Mac OS as I understand some of the VBA would be slightly different between windows and ios? I think VBA might be involved with this but I'm not 100% sure - see below.
Basically I need help creating two discount calculators in one. A user will need to be able to choose between 2 different types of discount calculators in the drop down (cell B4).
I have mocked most of this up in Excel myself including the formulas so hopefully it's easy to understand. I just need help with making this a dynamic form so the user can choose which calculator they want which is then returned in the sheet. Is this even possible??
The first "stacked discount" calculator I basically copied myself from the Omni calculator here: https://www.omnicalculator.com/finance/discount (select "double discount" under type of discount - as per screen shot).
The "second type of calculator" is a bit different as I need Excel to spit out the percentage itself - see cell F35.
Do you think it's possible to create these 2 calculators on one sheet in Excel and make it dynamic and look pretty like Omni? :)
Thanks for taking a look and I welcome your feedback!
I'd like to be able to create a dynamic discount calculator in Excel for Mac. Firstly, do you work with Mac OS as I understand some of the VBA would be slightly different between windows and ios? I think VBA might be involved with this but I'm not 100% sure - see below.
Basically I need help creating two discount calculators in one. A user will need to be able to choose between 2 different types of discount calculators in the drop down (cell B4).
I have mocked most of this up in Excel myself including the formulas so hopefully it's easy to understand. I just need help with making this a dynamic form so the user can choose which calculator they want which is then returned in the sheet. Is this even possible??
The first "stacked discount" calculator I basically copied myself from the Omni calculator here: https://www.omnicalculator.com/finance/discount (select "double discount" under type of discount - as per screen shot).
The "second type of calculator" is a bit different as I need Excel to spit out the percentage itself - see cell F35.
Do you think it's possible to create these 2 calculators on one sheet in Excel and make it dynamic and look pretty like Omni? :)
Thanks for taking a look and I welcome your feedback!
Lucy D.
100% (3)Projects Completed
3
Freelancers worked with
3
Projects awarded
25%
Last project
5 Apr 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies