Formula in all cells in a column

Posted by paulj3000 on Stack Overflow See other posts from Stack Overflow or by paulj3000
Published on 2010-04-09T05:31:08Z Indexed on 2010/04/09 5:33 UTC
Read the original article Hit count: 495

Filed under:

excel

|

html-helper

Hi,

Simple question:

I want to create a formula which, in column Cn, will compute the values of An * Bn.

example

column C1 = column A1 * column B1
column C2 = column A2 * column B2
column C3 = column A3 * column B3

...etc

all the way down to

column Cn = column An * column Bn

Thanks

© Stack Overflow or respective owner

Related posts about excel

Excel error "This workbook contains Excel 4.0 macros or Excel 5.0 modules"

as seen on Super User - Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error, "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to… >>> More
Open excel 2007 excel files and save as 97-2003 formats in VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving… >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
vba access values from excel workbook from another excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Any ideas why this code will not work? Workbooks.Open Filename:="C:\a.xls" Workbooks("a.xls").Activate Worksheets("b").Select Dim OutputArray(10, 10) OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value I'm trying to run a macro in one file (unnamed… >>> More
Excel workbook event order and usage when closing Excel

as seen on Stack Overflow - Search for 'Stack Overflow'
Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving… >>> More

Related posts about html-helper

Call asp.net mvc Html Helper within custom html helper with expression parameter

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to write an html helper extension within the asp.net mvc framework. public static MvcHtmlString PlatformNumericTextBoxFor<TModel>(this HtmlHelper instance, TModel model, Expression<Func<TModel,double>> selector) where TModel : TableServiceEntity { … >>> More
Upgrading MonoRail - $HtmlHelper.InputFile & $HtmlHelper.DateTime missing?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey all, I upgraded MonoRail to the latest version and now $HtmlHelper.InputFile and $HtmlHelper.DateTime don't get parsed. Were these removed and are there equivalents for these now? Thanks, Justin >>> More
Boolean with html helper Hidden and HiddenFor

as seen on Stack Overflow - Search for 'Stack Overflow'
What's up with this? The viewmodel variable is a bool with value true. <%= Html.HiddenFor(m => m.TheBool) %> <%= Html.Hidden("IsTimeExpanded",Model.TheBool) %> <input type="hidden" value="<%=Model.TheBool%>" name="TheBool" id="TheBool"> Results in: <input id="TheBool"… >>> More
What is the difference (if any) between Html.Partial(view, model) and Html.RenderPartial(view,model)

as seen on Stack Overflow - Search for 'Stack Overflow'
Other than the type it returns and the fact that you call it differently of course <% Html.RenderPartial(...); %> <%= Html.Partial(...) %> If they are different, why would you call one rather than the other one? The definitions: // Type: System.Web.Mvc.Html.RenderPartialExtensions //… >>> More
Persisting model state in ASP.NET MVC using Serialize HTMLHelper

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
ASP.NET MVC 2 futures assembly provides a HTML helper method Serialize that can be use for persisting your model object. The Serialize helper method will serialize the model object and will persist it in a hidden field in the HTML form. The Serialize helper is very useful when situations… >>> More