Question: For Column E, I need to make a formula with absolute cells that equal the values listed in E. The formula is a single price
For Column E, I need to make a formula with absolute cells that equal the values listed in E. The formula is a single price item times the quantity, with a 25% sale included if listed in cell D, what formula would I write to fulfill this goal? Thanks!
Supplies For Liam Paint Job On Single Item Price Item Quantity Sale Paint $10.00 5 N Brush $5.50 8 Y Roller $7.25 6 Y Drop Cloth $25.50 2N Ladder $32.45 3 Y Pre-Tax Price Tax $50.00 $33.00 $32.63 $51.00 $73.01 Total Price % of Total Sale $2.25 $ 52.25 20.86% $1.49 $ 34.49 13.77% $1.47 $ 34.10 13.62% $2.30 $ 53.30 21.28% $3.29 $ 76.30 30.47% Total Cost $ 250.42 Supplies for Liam Sales Percentage! Tax Rate 25% 4.50%! Ladder, 30.47% Paint, 20.86% Brush, 13.77% Drop Cloth, 21.28% Roller, 13.62%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
