Question: why am i getting N/a when I copy the formula down? . . Mark 11:24 NIV - Ther x | Burton Graduate Acce x Shiftgroup

why am i getting N/a when I copy the formula down?

. . Mark 11:24 NIV - Ther x | Burton Graduate Acce x Shiftgroup Connect X G berserk anime - Goog x |CengageNOWv2 | Onl x Excel Online Student X Chat Thread x + @ cxp.cengage.com/spreadsheet/wac_frame.jsp Q Co I Halloween II ( The... CAU Apps Career and Profes... The Leading Provi... C IT Support | Cours... A Canvas Dashboard Google Gemini in Notifications | Link... All Bookmarks X template - Saved Search for tools, help, and more (Option + Q) 3 1uotx9r File Home Insert Share Page Layout Formulas Data Review View Help Draw Comments Editing 1v Ov |Calibri (Body) 11 A" A B I U ab D v Ov Av Aa = v Wrap Merge Custom v SEv .0 . Conditional Formatting v Cell Styles v Format As Table of Insert fo Delete v Ev Q V 27 V Q V 88 ... M X fx =ROUND (IF (L5="yes", 0, K5*XLOOKUP (35, E5 : E9, F5: F9) ) , 2) N P Q R S T U V w X Z AA Location county County Rate Location Count Sale amount Tax-exempt sale Sales tax amount Axson Mall Gwinnett Clarke 8% ennesaw Mall Dekalb 2,361.00 188.8 Blackshear Street Hall Dekalb 8% Quitman Street Jackson 1,623.00 113.61 Chester Mall Clarke Gwinnett 6% Union Point Street Gwinnett 1,466.00 87.96 Eatonton Street Jackson Hall 7% Omaha Street Dekalb 973.00 #N/A Good Hope Center Dekalb Jackson Tyrone Cente Jackson 1,036.00 72.52 Hazlehurst Outlet Clarke Tyrone Center Jackson 1,107.00 #N/A Jasper Outlet Hall NOTE: The data in columns B, C, E, and F Hazlehurst Outlet Clarke 559.00 #N/A Kennesaw Mall Dekalb is used to complete columns J and L, Valona Center Hall 2,141.00 #N/ 10 Lavonia Center Clarke but is not part of the data for creating Tyrone Center Jackson 433.00 #N/A 11 Marble Hill Street Gwinnett pivot tables . Nicholson Avenue Jackson 1,709.00 #N/A 12 Nicholson Avenue Jackson Jasper Outlet Hall 1,660.00 #N/A 13 Omaha Street Dekalb Axson Mall Gwinnett 271.00 #N/A 14 Pendergrass Avenue Hall Valona Center Hall 2,064.00 #N/A 15 Quitman Street Jackson Hazlehurst Outlet Clarke 3,180.00 #N/ 16 Rocky Face Avenue winnett Rocky Face Avenue Gwinnett 2,320.00 #N/A 17 Stillmore Avenue Dekalb Marble Hill Street Gwinnett 2,715.00 #N/A 18 Tyrone Center Jackson Chester Mall Clarke 2,778.00 #N/A 19 Union Point Street Gwinnett Omaha Stree Dekalb 864.00 #N/A 20 Valona Center Hall Tyrone Center Jackson 1,549.00 #N/ 21 Winder Outlet Clarke Quitman Street Jackson 2,062.00 #N/A 22 Eatonton Street Jackson 2,582.00 #N/A 23 Rocky Face Avenue Gwinnett 1,114.00 #N/A 24 Marble Hill Street Gwinnett 55.0 #N/A 25 Chester Mall Clarke 2,589.00 #N/ 26 Good Hope Center Dekalb 3,337.00 #N/A 27 Jasper Outlet Hall 3,327.00 #N/A 28 Jasper Outlet Hall 2,045.00 #N/A 29 Chester Mall Clarke 2,418.00 #N 30 Union Point Street Gwinnett 1,862.00 #N/ Kennesaw Mall Dekalb 2,489.00 #N/A Stillmore Avenue Dekalb 252.00 #N/A Union Point Street Gwinnett 2,485.00 #N/A Lavonia Center Clarke 1,076.00 Stillmore Avenue Dekalb 945.00 Quitman Street Jackson 1,521.00 Pendergrass Avenue Hall 949.00 Marble Hill Street Gwinnett 1,351.00 Winder Outlet Clarke 171.00 Nicholson Avenue Jackson 2,770.00 Hazlehurst Outlet Clarke 1,942.00 Jasper Outle Hall 95.00 Omaha Stree Dekalb 1,000.00 Union Point Street Gwinnett 410.00 Nicholson Avenue Jackson 3,354.00 Omaha Stree Dekalb 909.00 Winder Outlet Clarke 2,111.00 Axson Mall Gwinnett 1,461.00 yes Ctillmars Aunnun nalmath 2 171 on =Data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock