Calculate the revenue per transaction


Problem: On the Store Transactions Summary worksheet, add a column named Revenue Per Transaction to the right side of the table. Enter a formula in cell D2 to calculate the revenue per transaction. Hint: Revenue per transaction equals the store revenue from the Store Revenue Summary worksheet divided by the number of transactions. Incorporate a VLOOKUP function in the formula using the Store ID value to ensure that you are using the appropriate store revenue in the calculation.

Request for Solution File

Ask an Expert for Answer!!
Accounting Basics: Calculate the revenue per transaction
Reference No:- TGS03426386

Expected delivery within 24 Hours