Get instant live Excel expert help to learn how to find range in Excel

In cell K6, enter a formula to determine the total cost of the rental based on the daily rate, the number of days rented, the cost of gas, and any discount given to the customer. Note that the discount applies only to the car rental, not the cost of gas. Copy the formula to the range K7:K32.

Switch to the Loan Options worksheet. In cell B12, create a formula using the PMT function to calculate the monthly payments for loan Option A. Use the values in cells B8, B10, and B5 for the Rate, Nper, and Pv arguments, respectively, and do not enter any values for the optional arguments. Copy the formula you created in cell B12 into the range C12:D12."

"The formula in this cell refers to a range that has additional numbers adjacent to it."

Hello. I would like to analyse two columns of values. If column A has a value in it I would like to subtract it from column B. I seem to be able to make this work for a single cell. See here .... =IF(A1>=0,IF(B1>=0,A1-B1)) However I can't seem to do it for a range of cells to give me a single value. Any suggestions?

I need to change the values in a row depending on whether a value is exceeded in a different range of cells on the "ACCU inputs" worksheet. I have completed the COUNTIF portion but cannot finish the task.

5. Go to the Necklace worksheet. Format the range A2:G16 as an Excel table with headers using the Table Style Medium 6 table style. (Hint: Depending on your version of Office, the table style may be named Blue, Table Style Medium 6 instead.) Use NecklaceSales as the name of the table.

create a line chart with YTD results of change requires. I would like two lines plotting monthly data points for % change required and total number of project change required. Please use the range of January 2018 to October 2018. provide a table that show the top 5 change required reasons. Please show the reason and the number of projects rejected with that reason code.

I'm trying to test for time within a range of times. I am using this formula, but Excel doesn't like it: =IF(AND(H2>00:00,H2<05:30),1,0) The referenced column is a TIME field, looks like this: Time 5:54 10:26 2:17 4:31 10:30

In the Insert Sparklines dialog, verify that B4:F13 is the Data Range and specify G4:G13 as the Location Range. Click OK.

I would like to identify based on the assumptions table 1. bases on segment (US,APac,emea,enterprise) if the age is within the expected range - return "expected" otherwise return "Risk"