In: Accounting
What is the formula I would insert into Excel
|
Academy | 6000 Southwest Freeway | (555) 399-2341 | Sports | $75.00 | Soccer Equipment | 45 | Delivery | $125 | Home | Pickup | ||
Ali's Hair Stylist | 1825 May Avenue | (555) 242-2530 | Spa | $50.00 | Shampoo, Conditioner, Spray | 36 | Pickup | $45 | Home | Delivery | ||
Ali's Hair Stylist | 1825 May Avenue | (555) 242-2530 | Spa | $50.00 | GC | 125 | Pickup | $55 | Sports | Pickup | ||
Ali's Hair Stylist | 1825 May Avenue | (555) 242-2530 | Spa | $50.00 | GC | 125 | Pickup | $55 | Sports | Delivery | ||
Avalon Burgers | 421 Montrose Blvd | (555) 578-7800 | Dining | $40.00 | GC | 5 | Pickup | $40 | Spa | Pickup | ||
Barry's Goldwater | 2216 S. Oklahoma Street | (555) 321-2311 | Dining | $100.00 | GC | 65 | Pickup | $95 | Spa | Delivery | ||
Barry's Goldwater | 2216 S. Oklahoma Street | (555) 321-2311 | Dining | $100.00 | GC | 65 | Pickup | $95 | Kids | Pickup | ||
Bounce Play Area | 3509 Bounce Circle | (555) 980-9808 | Kids | $25.00 | GC | 18 | Pickup | $30 | Kids | Delivery | ||
Brother's Burgers | 1100 Choctaw Lane | (555) 298-3322 | Dining | $40.00 | GC | 18 | Pickup | $40 | Vacation | Pickup |
I have created a sample copy of the worksheet using the data
provided in the question by you. You can refer to that for better
understanding.
While pasting the data, and the inserts a table for the data, I
have not named all the column, as that has not been mentioned in
the question.
I have only named the price column, as I assume it to be the header
of that column (column E), based on my inference from the
question.
The Delivery charges rate value has been written in B1 cell, as
stated by the question.
The delivery charges column has been inserted next to the price
column, and has been highlighted in orange (column F).
The excel formula for calculating delivery charges (i.e. column F) has been mentioned in cell F1 and highlighted in orange.
Note : The formula for the cell is $B$1 * [@Price].
However, in case the name of the column which I have labelled as 'Price' is something else, like 'Price Rate' for example. then the formula would be changed to $B$1 * [@[Price Rate]]
Also please remeber that structured referencing first would require you to insert a table for the entire dataset that is the subject in the question.