nested “if” function, business and finance homework help

  

help please
here__2_.xlsx

Unformatted Attachment Preview

Customer Number 111-111-1
Order Number
222-222-2
ORDER FORM
Quantity
1
1
2
2
2
6
Item Number
123-04
192-45
1256-67
3427-1
231-00
453-22
Description
3″ Stanley Plane
Dovetail Saw
3″ hinges (pair)
4″ brass hinges (pair)
Brass Box Lock
1″ Drawer pull
NAME
ADDRESS
CITY
STATE
ZIP
Joe Customer
123 Main St
Spokane
WA
99217
Cost
$
$
$
$
$
$
Extension
$
24.95
$
29.95
$
7.90
$
9.90
$
13.00
$
5.34
$
$
$
91.04
24.95
29.95
3.95
4.95
6.50
0.89
SUBTOTAL
SHIPPING
SALES TAX
GRAND
TOTAL
Under
Between
Between
Between
Between
Between
Between
Over
IF_exercise.xls
5/7/2019
$
$
$
$
$
$
$
Shipping Charges
$
10.00 $
25.00 $
40.00 $
55.00 $
70.00 $
85.00 $
100.00
–
9.99
24.99
39.99
54.99
69.99
84.99
99.99
$
$
$
$
$
$
$
$
3.95
4.95
5.95
6.95
7.95
8.95
9.95
10.95
$
7.83
$
91.04
Create a “nested” IF finction in
Cell E17 which will test the
subtotal amount (E16) to find
where it appears in the Shipping
Charges table and enter the
correct value for shipping ANY
order. Consider the logic of the
situation carefully and ensure that
your IF function will work for any
amount in Cell E16. (test by
changing the value in cell E16)
To print, put a header with your
name and class ID on the sheet;
shift into formula view, widen
column E as necessary to ensure
that the entire function may be
read, select the cell E17 and print
ONLY the selection.
ensure that
y to ensure
and print
IF_exercise.xls
5/7/2019
…
Purchase answer to see full
attachment