Please write a code that would run in VBA excel and please only use the data types attached thanks A warehouse gives a discount to customers based on the number of units sold. The current, non-discounted price is $75/unit. Write a procedure that gets the number of units the customer is buying viaan input box. Send that number of units to a function which will return the discount. The originalprocedure will then calculate the total cost and puts all information on a spreadsheet. Be sure toproperly format, via code, the information going on the spreadsheet. The discount schedule is:DISCOUNT (ON TOTALCOST)UNITS SOLD100-2005%201-50010%501-100015%>100020% Data Types.pdfData Type or RequiredVariableDefault ValueRangeSubtypeMemoryPrefixInteger2 bytesint-32,768 to 32,767Long4 bytesIng-2,147,483,648 to 2,147,486,647Single4 bytessng-3402823E38 to -1.401298E-45 or 1.401298E-45 to3.402823E38Double8 bytesdbl-1.79769313486232E308 to -4.94065645841247E-324 or1.79769313486232E308 to 4.94065645841247E3248 bytes-922,337,203,477.5808 to 922,337,203,685,477.5807CurrencycurDate8 bytes00:00:00dtmJanuary 1, 100 to December 31, 9999Number of spaces toString'slengthStringstr1 to 65,400 charactersaccommodate string(fixed length)Object4 bytesNothing (vbNothing)objAny Office object, ActiveX component or Class object2 bytes-1 (true) or 0 (false)BooleanFalsebln

Objective: A function should be written in Excel VBA to receive the number of units for a warehouse…

A warehouse gives a discount to customers based on the number of units sold. The current, non- discounted price is $75/unit. Write a procedure that gets the number of units the customer is buying via an input box. Send that number of units to a function which will return the discount. The original procedure will then calculate the total cost and puts all information on a spreadsheet. Be sure to properly format, via code, the information going on the spreadsheet. The discount schedule is: DISCOUNT (ON TOTAL UNITS SOLD COST) 100-200 5% 201-500 10% 501-1000 15% >1000 20%

A warehouse gives a discount to customers based on the number of units sold. The current, non- discounted price is $75/unit. Write a procedure that gets the number of units the customer is buying via an input box. Send that number of units to a function which will return the discount. The original procedure will then calculate the total cost and puts all information on a spreadsheet. Be sure to properly format, via code, the information going on the spreadsheet. The discount schedule is: DISCOUNT (ON TOTAL UNITS SOLD COST) 100-200 5% 201-500 10% 501-1000 15% >1000 20%

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section8.1: Logical Functions

Problem 3QC

See similar textbooks

Similar questions

In G2:G11, the values should evaluate to the surname and the first character of the first name, with some punctuation. For example G2 should evaluate to Johnson R. What function should be used to achieve this? Choices: A. CONCATENATE B. MIN,MAX C. SEARCH D. RANK E. No choice given
In G2:G11, the values should evaluate to the surname and the first character of the first name, with some punctuation. For example G2 should evaluate to Johnson R. What function should be used to achieve this? Min_Max Concatenate Rank No choice given Search
Write a function that determines the number of missing entries for a specified column in the dataset. The function should return a string detailing the number of missing values.Function Specifications: Should take a pandas DataFrame and a column_name as input and return a string as output. The string should detial the number of missing entries in the column. Should be generalised to be able to work on ANY dataframe. ### START FUNCTION def total_missing(df,column_name): #code total_missing(df,'Age') Expected Outputs: total_missing(df,'Age') == "Age has 177 missing values" total_missing" (df,'Survived') == "Survived has 0 missing values"
A handle to a function which returns a vector of rates of change Group of answer choices @F Xo % Timespan
Programming Assign. Unit 5 Part 1 Encapsulate the following Python code from Section 7.5 in a function named my_sqrt that takes a as a parameter, chooses a starting value for x, and returns an estimate of the square root of a. while True: y = (x + a/x) / 2.0 if y == x: break x = y Part 2 Write a function named test_sqrt that prints a table like the following using a while loop, where "diff" is the absolute value of the difference between my_sqrt(a) and math.sqrt(a). a = 1 | my_sqrt(a) = 1 | math.sqrt(a) = 1.0 | diff = 0.0 a = 2 | my_sqrt(a) = 1.41421356237 | math.sqrt(a) = 1.41421356237 | diff = 2.22044604925e-16 a = 3 | my_sqrt(a) = 1.73205080757 | math.sqrt(a) = 1.73205080757 | diff = 0.0 a = 4 | my_sqrt(a) = 2.0 | math.sqrt(a) = 2.0 | diff = 0.0 a = 5 | my_sqrt(a) = 2.2360679775 | math.sqrt(a) = 2.2360679775 | diff = 0.0 a = 6 | my_sqrt(a) = 2.44948974278 | math.sqrt(a) = 2.44948974278 | diff = 0.0 a = 7 | my_sqrt(a) = 2.64575131106 | math.sqrt(a)…
Answer this question in JavaScript: Use the weather data set that's provided in the code var weatherData = [ { 'location': 'Paris', 'temp in C': 27.1, 'wind in kph': 38.4 }, { 'location': 'Nairobi', 'temp in C': 38.2, 'wind in kph': 3.5 }, { 'location': 'San Francisco', 'temp in C': 15.7, 'wind in kph': 12.8 }, { 'location': 'Tokyo', 'temp in C': 20.4, 'wind in kph': 8.8 } ]; Write a function to output a temperature graph like: Paris @@@@@@@@@@@@@@@ 27.1 Nairobi @@@@@@@@@@@@@@@@@@@@ 38.2 San Francisco @@@@@@@@ 15.7 Tokyo @@@@@@@@@@ 20.4 You should also write a function that produces a similar graph, but vertica
This is my main.cpp, if there's anything wrong with it in relation to the assignment, please point it out and how to solve it. I can't get my functions.cpp to connect properly to the main.cpp. I need the functions.cpp first, anything else comes second. Thank you very much. main.cpp: #include <iostream> #include <fstream> #include <iomanip> #include <string> #include "functions.cpp" using namespace std; //struct for menuItemType struct menuItemType { string menuItem; double menuPrice; } void getData(menuItemType menuList[]); void showMenu(menuItemType menuList[], int x); void printCheck(menuItemType menuList[], int menuOrder[], int x); int main(); { // Declare functions and variables const int menuItems = 8; menuItemType menuList[menuItems]; int menuOrder[menuItems] = {0}; int orderChoice = 0; bool ordering = true; int count = 0; // Set the menu getData(menuList);…
A teacher is compiling data and needs to find the number of B grades. A B grade is any score greater than 79 and less than 90. If the data is listed in B1 through B210, which function would count the grades correctly? a. =COUNTIFS(B1:B210,>79,B1:B210,<90) b. =COUNTIF(B1:B210,">79") c. =COUNTIFS(B1:B210,">79",B1:B210,"<90") d. =COUNTIFS(B1:B210,">79","<90")
) Write a function that updates the year of a student, i.e. if year is “Year1”, then update to “Year2”, if year is “Year2”, then update to “Year3”, if the year is “Year3” then updated to “Graduated”.
The accompanying Homeownership spreadsheet contains a partially completed spreadsheet model for computing the monthly costs of home ownership. Complete the spreadsheet model by inserting the formulas for monthly mortgage payment, monthly property tax, monthly homeowner insurance premium, monthly maintenance costs , and total in the appropriate cells. Variables: House value: $ 450,000.00 Interest rate: 4.25% Down payment (% of house value): 20% Number of years: 30 Property tax rate: 1.25% Annual homeowner insurance premium: $ 1,400.00 Maintenance cost rate (% of house value): 1% Monthly Cost of Home Ownership Monthly mortgage payment: Monthly property tax: Monthly homeower insurance premium: Monthly maintenance costs: Total: 1. Is this a deterministic or stochastic model? 2. Which of the following is NOT an input of the spreadsheet model? A. Interest rate B. Monthly mortgage payment C. Number of years of…
Write a function to describe the following scenario. Jonathan is selling his old trading cards. Each customer that buys gets the first box they purchase for $10, and each additional box for only $5.
Write a python program that return the total aquaculture production by Year, Region, and Type/Environment. You must disregard the Philippines in the region column. Use groupby to group rows according to the Year, Region, Type/Environment then apply the sum function to the Volume column to return total production per year. Create a line chart of the result that can be filtered by Type/Environment. Set the hvplot x parameter to Year and by parameter to Region, and groupby parameter to Type/Environment. Here is the dataset: