How to use the iferror and hlookup functions

Assignment Help Financial Accounting
Reference no: EM13501650

Below is select sales data for RX Industries. The orders range from 1 to 20, however any returned or canceled orders have been deleted from the data. Use the template below to create an order summary that automatically shows the data for any selected order ID between 1 and 20. Hint: Use the IFERROR and HLOOKUP functions. The function for any order ID in the range that has been deleted should return the phrase "Not Found."

OrderID 1 7 9 13 16 2 3
Region East East East East East West West
OrderDate 1/10/2009 3/6/2009 3/28/2009 4/8/2009 4/12/2009 5/16/2009 5/23/2009
OrderAmt  $1,122.00  $  4,453.00  $   1,305.00  $2,708.00  $1,502.00  $4,796.00  $1,526.00

 

5 10 14 4 8 11 17 18
West West West Central Central Central Central Central
6/2/2009 7/8/2009 7/30/2009 8/29/2009 9/9/2009 10/5/2009 11/16/2009 12/25/2009
 $1,523.00  $2,068.00  $1,597.00  $ 781.00  $2,976.00  $4,145.00  $3,979.00  $2,044.00

 

 

Reference no: EM13501650

Questions Cloud

Watch the amounts change in cells c4 and h4 : Look at the formulas in C4 and H4. They use the lookup function to compare the part number in B3 to the numbers in C6:F6, and "scan" the array table values in C7:F12 to find the sales in units for each month.
What is the value of the final steady-state current : Consider the circuit in the figure below. Take emf = 6.00 V, L = 7.00 mH, and R = 6.00 O. What is the value of the final steady-state current
Explain what is the molar mass of the substance : A solution of 2.00 g of para-dichlorobenzene (a clothes moth repellent) in 50.0 g of cyclohexane freezes at 1.05 degrees Celsius. What is the molar mass of this substance?
What is the index of refraction of the walls : To a fish, the 4.20 mm thick aquarium walls appear to be only 3.80 mm thick. What is the index of refraction of the walls
How to use the iferror and hlookup functions : Use the template below to create an order summary that automatically shows the data for any selected order ID between 1 and 20.
What is the probability of finding metal fully magnetized : A tiny piece of metal contains 100 magnetic spins. At room temperature, there is an equal likelihood for an individual spin to be "up" versus "down." What is the probability of finding the metal fully magnetized
Explain solutions in order of increasing freezing points : Arrange the following aqueous solutions in order of increasing freezing points (lowest to highest temperature): 0.10 m glucose, 0.10 m BaCl2, 0.20 m NaCl, and 0.20 m Na2SO4.
Calculate the resistance of wire and its current : A wire 2.0mm in diameter and 4cmlong is connected to a 12V battery. If the resistivity of the wire is 3.5 x 10^-5 ohm-m; calculate the resistance of wire and its current
What is the angular seperation between adjacent maxima : Two narrow slits 0.328 mm apart are illuminated by light of wavelength 600. nm. What is the angular seperation between adjacent maxima

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculate the total amount of dividends

Calculate the total amount of dividends declared by March for 20X7 and calculate March's profit for 20X8.

  Federal income tax purposes

Thelma thus selld the property to Paul (an unrelated party) for $65,000. On the next day, Paul sells the property to Sandy for the same amount. Is Thelma's realized loss of $55,000 deductible? Describe.

  Astaire company uses the gross profit method to estimate

astaire company uses the gross profit method to estimate inventory for monthly reporting purposes. presented below is

  Analyze laundry costs for the month of september

During the month of September, the hospital had 18,000 patient days. Total laundry costs were $142,000. Calculate the controllable overhead variance. Analyze laundry costs for the month of September.

  Perfect gas corporation supplies compressed gases to

perfect gas corporation supplies compressed gases to business customers. data regarding the stores operations given

  Multiple choice question based on variance analysis

Multiple choice question based on Variance Analysis - The direct material price variance for May is (note that the purchase price variance is based on the amount purchased

  Assets and current liabilities and impact on cash flow

Determinants of cash flows. We examine determinants of operating cash flow to assess the quality of operating cash flow. Determinants are components. Specifically, we study the change of accounts of current assets and current liabilities and their..

  Describe the manufacturing process

Identify what types of trends you should be aware of in the industry and who the primary competitors are.

  At december 31 2007 western trading co owned the following

at december 31 2007 western trading co. owned the following investments in the capital stock of publicly owned

  Evaluate the amount of gross profit

Evaluate the amount of gross profit or loss to be recognized in each of the three years using the completed contract technique.

  What is best estimate of the company net operating income

Seyal Inc.'s contribution margin ratio is 55% and its fixed monthly expenses are $34,000. Assuming that the fixed monthly expenses do not change, what is best estimate of the company's net operating income in a month when sales are $94,000?

  Effect on the financial performance of the organisation

Not having an accounting background, the owner Joe Logs, does not understand the concept of depreciation and is under the impression that depreciation is a process of creating a cash fund to replace an asset.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd