Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask ATLPROG Your Own Question

ATLPROG, Computer Software Engineer

Category: Programming

Satisfied Customers: 7677

Experience: MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

44910485

Type Your Programming Question Here...

ATLPROG is online now

I have a Excel Function programming question. I would like

Customer Question

Hi, I have a Excel Function programming question. I would like to create a Function that has a calculation in ThisWorksheet. The worksheet would be named “Calculator” and has inputs in column B (B2 – B15) and one output in cell I11 based on calculations done in the sheet using the inputs. I would like to create a Function with arguments that match the inputs in the Calculator worksheet. I would like the function to read these arguments into Column B of the Calculator worksheet and set the result of the Function to be the value in cell I11 of the Calculator worksheet. Is this doable? How? Thanks, II

Please, be forewarned that the site is not secure:

- Click the following link: http://www.wikisend.com - Upload the file to that website - Once it is uploaded, the resulting page will display a "File ID" number. - Please, give me that "File ID Number"

Hi Jason, I am having some problems uploading the excel file.simple example:Function is called AF and has 2 arguments You open AF and enter 1 as the 1st argument and 2 as the second argument In Sheet 1 of the excel file , 1 is entered to cell A1 and 2 is entered into cell A2. Cell A3 has a formula that is 2xA1+A2, so cell A3 has a value of 4 and the function AF returns a result of 4, i.e. function result is equal to value in cell A3 or the sheet.

I sent the email. I put a simple calculation in the worksheet but the actual calculation is very complicated and hard to program just in VB that is why I want to know if this method would work.

I need the inputs(arguments) into the function to be copied to the corresponding cells (column B) in Sheet 1 (Calculator) so that the calculation in cell I4 of Sheet 1 (Calculator) is based on the function inputs and the function returns the value in cell I4.For example if the inputs in the function are 55,65,66,62,63,54,65,66,67,68,69,70,71,72 then the function should result in a value of 834 (see cell I4)