Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-14-2010, 02:09 PM
ECPL_3 ECPL_3 is offline Associated operation Windows XP Associated operation Office 2003
Novice
Associated operation
 
Join Date: Nov 2009
Posts: 3
ECPL_3 is on a distinguished road
Default Associated operation

Hello,
Is there any way to do associated operations in Excel similar to that of Matlab?

In my simplified example, I want to change the tedious formula of "'=$D$3*D16+$E$3*E16+$F$3*F16+$G$3*G16" to something that looks like Rates*Hours, but the rates and hours would for a range of all the columns in the selected area.


Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
OUTLOOK : the operation failed. an object cannot be found luotzabl Outlook 0 02-28-2010 02:48 AM
Associated operation Basic operation of Excel not working! praveen_p Excel 2 04-23-2009 10:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft