Tech Tip
We have all written programs to create comma delimited files for import into Excel. Check this .csv out.
"Product","Qty","Dollar","Extend Dollar"
"500-12","12","$100.00","$1200.00"
"389-HW","1","$50.00","$50.00"
"9088-9","2","$75.00","$150.00"
"19879-FIL","1","$20.00","$20.00"
"9876-98","1","$10.00","$10.00"
"75-P","3","$5.00","$15.00"
"","","=SUM(C2:C7)","=SUM(D2:D7)"
Quite ordinary wouldn't you say? But examine the last line. Instead of adding the Dollar and Extend Dollar columns in the program, insert the Excel formula to do the calculation in the spreadsheet. Those with keen eyes will notice that the same thing could be done for the Extend Dollar column.
