i NEED HELP FINDING THOSE FORMULASPLEASE
IVE TRIED A MILLION TIMES AND NEVER COULD FIND IT
THANK YOU
Solutiom:
Step 2: Calculate no. of days
This is pretty straightforward. Excel lets you use arithmetic operations on dates. So, if you want to calculate no. of days between 2 dates, you simply subtract the two. The formula is as shown:
Step 4: Lookup function
For this you use a function called VLOOKUP. The formula implementation looks like this:
How it works?
The function takes in four values which are:
Step 6: Discount formula
You can use the IF statement along with OR function here. It looks like this
IF function takes in three values IF(logical statement, value if true, value if false)
Step 8: Total cost
Days rented * Daily rate * (1 - discount) + Gas cost
Thank you!
i NEED HELP FINDING THOSE FORMULASPLEASE IVE TRIED A MILLION TIMES AND NEVER COULD FIND IT...
tRYING TO FIND THESE FORMULAS! THASNK YOU Step Instruction Earned Possible On the RentalData worksheet, in cell E6, enter a date formula to determine the length of rental in days. Copy this formula to the range E7 E32. 2 In cell G6, use the appropriate lookup and reference function to retrieve the rental rate from the named range RentalRates. The function should look for an exact matching value from column A in the data. Copy the function down the column...
I need help how to do the steps 9, 10, 11 A1 x Day A fx B C D E F G H I J K Afternoon Sales over $100 Shift Cups Sold Kids Sold Kids sold Cups sold (6 oz) (12 oz) 54 52 14 28 Hours Morning Afternoon Evening 1 Day 2 Sun 3 Sun 4 Mon 5 Mon 6 Tue 7 Tue 8 Wed 9 Wed | 10 Thu | 11 Thu 12 Fri 13 Fri 14...
I have completed these but wanting to compare such as Question 14. Is the word "Total" added in the row or written as "Average" or "Total Average" Also Question 8 is not clear what fill color. Is it supposed to stay as blue and just select gradient fill? Very unclear questions. Thank you. Question: EX16_XL_VOL1_GRADER_CAP_AS – Travel Vacations 1.4 ( Excel, Chapter 4) Project Description: 1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 2 On the DC worksheet,...
Hello I was wondering if you could give me the formula that I need to put in cell F4. The hint is down at the bottom right beside social security tax deduction. It gives a hint of how to put the formula together but I am so confused. The answer should come out to be $3,382 in cell F4 if done correctly. Thanks for your help! F4 Federal Medicare Soc Sec Tax Std. Deduction for each dependent: up to Max...
REINFORCE YOUR SKILLS: E8-R3 Calculate Company Matching Amount In this exercise, you will look up the amount employees will receive into their retirement savings after Kids for Change decides to implement a tiered system to encourage employees to save more for retirement. 1. Open the E8-R3-Savings file from the Excel Chapter 8 folder and save it as E8-R3-SavingsMatched. 2. Select cell H8, if necessary. 3. Insert a VLOOKUP function. 4. For the Lookup_Value, select cell G8. 5. For the Table_Array,...
I REALLY NEED HELP THERE IS NO OTHER INFORMATION GIVEN AND IF I DON"T FINISH THIS I RISK FAILING THE CLASS PLEASE READ CAREFULLY THIS IS WHAT THE ANSWERS SHOULD LOOK LIKE o a8 points Previcus Ahswers TaalmanCaic1 1.2.066. 3/6 Submissions Used My Notes Ask Your Teacher Len's company produces different-sized cylindrical cans that are each 6 inches tall. The cost to produce a can with radius r is C 10Onr24mr cents. Different cans with radius 6 inches Cost of...
Could anyone help me with the lookup function for #5? Plain Text Tahoma Start Excel. Open the file named ex02TravelAgency START Save the file with the name 0.000 ex02TravelAgency LastFirst, replacing LastFirst with your name. On the Agency Clients worksheet, apply the Table Style Light 14 to the Clients named range. Note, the style may be named Green, Table Style Light 14, depending on the version of Office used. 2 2.000 3 named ranges for each of the column headings...
Hello, I need some help with some Excel formulas. a. Open Excel_Ch11HW.xlsx and save it as Excel_Ch11HW_LastNameFirstName. b. Click cell H4, the cell containing the ending date for the first loan. Enter the formula to compute the ending date, based on the starting date and the term of the loan. For the sake of simplicity, you don’t have to account for leap year. To compute the ending date, multiply the term of the loan by 365 and add that result...
i need help making this program the skeleton of the code is below: //Include the following #include <iostream> #include <string> #include <fstream> //you must include this library if you wish to do file i/o using namespace std; /********************************************************* //Following is the declaration of a order record **********************************************************/ class order_record { public: string cell_number; string item_number; double quantity; double price; int processing_plant; double tax_rate; double order_tax; double net_cost; double total_cost; }; //Prototypes for your functions: input, output, and process will go...
Instructions 1-17 sheet 1 sheet 2 Should be done on exel file. Assignment Instructions Step Instructions Point Value Open the Excel file Student_Excel_2F_Bonus xlsx downloaded with this project. Rename Sheet1 as Northern and rename Sheet2 as Southern Click the Northern sheet tab to make it the active sheet, and then group the worksheets. In cell A1, type Rosedale Landscape and Garden and then Merge & Center the text across the range A1 F1. Apply the Title cell style. Merge &...