Excel formula needed. In column G enter a formula with the IF function to calculate the days past due. If the number of days since the invoice was sent (current date-invoice date) is greater than 30, calculate the days past due (current date-invoice date- 30); otherwise enter 0.

Sales | Sales Rep-I commissi Invoice Days Past 2 Com 3 Consortium for Ocean Leadership 4 MRSI Group, Inc 5 Natural Environment Research Co 6 Alpharma,Inc 7 Cardio Tech International Inc. 8 Image Acoustics, Inc. 9 Ocean Dynamics Inc. 10 Materials Sciences Corporation 11 I. M. A. Dynamite Group, Inc. 12 Marine BioConversion, LLC 13 New Medical Center 14 Advanced Scientific Concepts, Inc. 15 American Heart Association 16 Lyme Disease Assoc of NJ 17 Pro Change Behavior Systems 18 American Psychology Foundation 19 CSCS Corp. 20 Global Environment & Technology Foundation Lesure 21 Perry Institute for Marine Science 22 Save the Lions o-Amou_ Due Currert-1-31 Johnson Boehmer $ Lesure Lesure Boehmer Lesure Boehmer Johnson Boehmer Riley Boehmer Lesure Lesure Boehmer Johnsorn Lesure Riley $ 2,142.40 155.40 $1,414.80 HN/A144.00 #N/A |$ 164.40 #N/A | $ 4,819.40 #N/A | $ 452.00 #N/A : $ 1,174.00 #N/A | $3,868.60 #N/A | $ 1,194.00 #N/A $ 802.00 #N/A : $ 2,123.20 #N/A $ 1,814.30 #N/A | $ 2,210.80 N/A S 713.30 HN/A $1,328.00 #N/A $182.40! #N/A $704.00 #N/A $ 550.30 #N/A $816.30 s h Boehmer Johnson , Documentation Invoices Invoice Reports Commission e e Class 6-Excel Modu How to Calculate C- Case2 cs135 Excel