HELP PLEASE! 500*3.33=1665 so what excel formula would make that true. When you do excel formulas you get 1666.67 so how would you get 1665? I have tried =500*3.33=1666.67 or =d22*f22 it still equals 1666.67. I have did rounds formulas, sum, and product. No numbers can be in the formula it is only suppose to be cells.

AutoSave On !! JE Task 1 submit.Saved - Search (Alt+a) Calista Daniels File Home Insert Draw Page Layout Formulas Data Reviow View Developer Help QuickBooks Comments Share fx Calculate Now Insert Function 0 Autosum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library Deine Name Use in Formula Name Manager Create from Selection Defined Names e Irace Precedents Show Formulas Fa Trace Dependents Error Checking Hemove Arrows Evaluate Formula Formula Auditing Watch Window Calculation El Calcite Sheet Options Calculation J22 G H K A 19 Address: B 123 Main Street, Anywhere, WI 53xxx D Contact: Invoice Date: February 15, 2022 20 21 Hand-Calculated Price Corrected Formula Price Room Item # Description Square footage Unit Price Price 22 Living Room C-1005 Lucky One 500 $3.33 $ $1,656.67 500*3.33-1565 23 kitcheri F-2210 Laminale - Lilepuol 150 9.75 1,462.BB 150*9.75-1462.50 24 Master Bedroom C 1015 Bellbury 245 $4.02 983.77 245*4.02-984.9 25 Master Bath F-2230 F Tile - Natural Stone 120 12.88 1,545.00 120*12.88-1545.6 26 Bedrourn #1 C-1025 Boxluni 180 $5.00 B99.40 180*5.00-900 27 Bedroom #2 C 1030 Bluft 180 $5.49 988.74 1805.49-988.2 28 29 30 31 32 Subtotal $7,546.45 $7,516.20 SUMU22:127) 33 Sales Tax (5.5%) % 415.06 415.04 132*5.5% Part A Parts & C Enter LO 1005 O L a 2:59 PM 2/2/2022