Return to article: How to Use Cell Ranges in Excel Formulas
on 11/22/2005 Excel will let you off the hook if your forget the final ) after a range in a formula. Try "=SUM(A1:B5" and watch Excel be "forgiving" - a rare thing for software!
on 11/22/2005 Lotus 123 uses cell ranges such as "A1..B5". Note: The ".." instead of Excel's ":". Excel will, however, convert the ".." or "." to ":" automatically.
Copyright © 1999-2008 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.
Partner Sites
