Create the following formula to assign the value in the Invoice Amount column to one of five columns-current 1-30 days, 31-60 days, 61-90 days, and over 90 days. A. In current (column H), if the days past due equals 0, display the invoice amount (column F); otherwise, display a blank cell.

File Inset Dr Pege Layout Formulas Data Revie V Home Data Review View Developer Design . Accounting I u Format Painter Clipboard A-| . Mergr&Center . | $ . % ,"Mig | Conditional FormatCell Formatting Table Styles Insert Delete Format Clear. Alignment Sales Invoice Days Past sales RepCommissioAmounDue Current 1.30 31-60 dai 61-90 days Over 90 dal 3 Consortium for Ocean Leadership Johnson $ 128.54 $2,142.40 MRSI GrOUup, Inc Bochmer aturalEnvironment Research Co. SA414 80| 6 Alpharma,inc BoehmerA164.40 mer m/A S 452.0 Cardio Tech International Inc. Acoustics, Inc N/A $4,819.40 Ocean Dynamics Inc. Materials Sciences Corporation LMA. Dynamite Group, Inc. Marine BioConversion, LLC Johnson Boehmer N/A $1,174.00 A$3,868.60 13 New Medical Center N/A $ 802.00 #N/A : $ 2,123.20 | N/A $1,814.80 INA$2.210.80 SN/A .. $-713.30 N/A S1,328.00 #N/A $ 182.40 #N/A $704.00 ! Advanced Scientific Concepts, Inc American Heart Association Lesure 16 Lyme Disease Assoc of N Pro Change Behavior Systems American Psychology Foundation CsCS Corp. : Global Environment & Technology Foundation Perry Institute for Marine Science Save the Lions Lesure Boehmer ohnson N/A S 550.80 WN/A S 816.30 Documentation Involces Invoice Reports Commission e e Class 6-Enel Mod. How to Calculate C. Case2