for the net price column shipping is free if the price with discount if applicable is over 50.00 or more

Formulas Data Review View Help & Cut Arial [ Copy - 12 - A A E ap Wrap Text Genera Paste Format Painter BI U - - CA v EZE E Merge & Center $ Clipboard Font Alignment F8 X CO OO N O) UI A W N D B C D E F G H 238.00 $24.20 6.50 68.00 $ 4.60 $ 7.80 13.00 $ 5.70 78.50 $ 11.20 27.90 $ 5.40 180.40 55.30 $ 16.70 $ 4.60 10 44.80 $ 5.80 11 56.60 $ 7.20 12 60.00 $ 6.80 13 13.75 $ 4.50 14 149.10 $ 27.90 15 26.25 $ 5.60 16 53.80 $ 7.30 22 17 59.70 $ 6.40 23 18 119.30 $ 17.20 24 25 Price discount le Discount amount 26 $ 60.00 5% 27 28 Rule: Use the IF function to calculate both columns. For the 'Price w/discount if applicable' column: If the price is at least at the 'Price discount level'($60) then apply the 'Discount 29 amount' (5%) to the price. 30 Problem 1 Problem 2 Problem 3 + Type here to search O a TAL