I'm calculating a range (15-25%) of a variable in another excel cell and want this new cell to answer with the range (.15*b27 to .25*b27), rather than a single answer. Is this possible?

Ad

Yes, Concatenate is the name of the formula.

ex:

=CONCATENATE(.15*B27," to ",.25*B27)

Which would return something like: "15.1254 to 25.5514"

If you want to limit the numbers in the returned data to whole numbers, you need to add the Floor formula.

ex.

=CONCATENATE(FLOOR(.15*B27,1)," to ",FLOOR(.25*B27,1))

That would return something like "15 to 25"

Posted on Dec 29, 2008

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

In statistics, the range of 1-var a data set is the difference between the largest value and the smallest. R=Xmax-Xmin

In functions: the range of a function is the interval (or the Union of intervals) of the real line where the dependent variable takes it values.

Ex: sin(x). Whatever the value of the independent variable x, the values of the function sin(x) are in the closed interval [-1,1]. The range of the functions sin(x), and cos(x) is**[-1,1]**.

**No use of a calculator for finding the range of functions.**

In functions: the range of a function is the interval (or the Union of intervals) of the real line where the dependent variable takes it values.

Ex: sin(x). Whatever the value of the independent variable x, the values of the function sin(x) are in the closed interval [-1,1]. The range of the functions sin(x), and cos(x) is

Feb 04, 2014 | Casio Calculator Graphing FX 9750GII...

I do not know of any TI calculator with Model number 53, but I will try to give a general answer. If you get a window range error that means that the Window limits are not set correctly. For example, the lower limit in X, Xmin must be algebraically smaller that the upper limit, Xmax. The default for the TI graphing calculators are Xmin=-10, and Xmax=10. Similarly the Ymin must be smaller than Ymax. The default limits for the y-variable are Ymin=-10, and Ymax=10. If your calculator has a Zoom function ( if it is a graphing calculator, it must have it) then Press Zoom key and select Zoom Standard or ZoomStd.

Jul 16, 2011 | Texas Instruments TI-89 Calculator

The IRR function is provided by Excel so you can calculate an
internal rate of return for a series of values. The IRR is the interest
rate accrued on an investment
consisting of payments and income that occur at the same regular
periods. In the values provided to the function, you enter payments you
make as negative values and income you receive as positive values.

For instance, let's say you are investing in your daughter's business, and she will make payments back to you annually over the course of four years. You are planning to invest $50,000, and you expect to receive $10,000 in the first year, $17,500 in the second year, $25,000 in the third, and $30,000 in the fourth.

Since the $50,000 is money you are paying out, it is entered in Excel as a negative value. The other values are entered as positive values. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. To calculate the internal rate of return, you would use the following formula:

=IRR(D4:D8)

The function returns an IRR of 19.49%.

The ranges you use with the IRR function must include at least one payment and one receipt. If you get a #NUM error, and you have included payments and receipts in the range, then Excel needs more information to calculate the IRR. Specifically, you need to provide a "starting guess" for Excel to work with. For example:

=IRR(D4:D8, -5%)

This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range.

For instance, let's say you are investing in your daughter's business, and she will make payments back to you annually over the course of four years. You are planning to invest $50,000, and you expect to receive $10,000 in the first year, $17,500 in the second year, $25,000 in the third, and $30,000 in the fourth.

Since the $50,000 is money you are paying out, it is entered in Excel as a negative value. The other values are entered as positive values. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. To calculate the internal rate of return, you would use the following formula:

=IRR(D4:D8)

The function returns an IRR of 19.49%.

The ranges you use with the IRR function must include at least one payment and one receipt. If you get a #NUM error, and you have included payments and receipts in the range, then Excel needs more information to calculate the IRR. Specifically, you need to provide a "starting guess" for Excel to work with. For example:

=IRR(D4:D8, -5%)

This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range.

Jun 09, 2010 | Microsoft Office Professional 2007 Full...

If you want to transfer your data into SAS, SPSS, or some other program,
follow these guidelines:

The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as $, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.

In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.

The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).

For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as $, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.

In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.

The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).

For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)

You may want to try =COUNT(A1:C9) for example. In brackets type the range of cells you want to count and excel will give you the number of cells that contain numbers.

Aug 19, 2008 | Computers & Internet

Hi you can Apply below mention formula

=ABS(SUM(COUNTIF(RANGE,"CATAGARI")-(COUNTIF(RANGE,"CATAGARI")))

RANGE = FROM WHICH CELL TO YOU WANT TO APPLY THIS FORMULA TO TILL WHICH CELL.

CATAGARI = WHAT DO U WANT < FOR FOR FIRST > FOR SECOND

=ABS(SUM(COUNTIF(RANGE,"CATAGARI")-(COUNTIF(RANGE,"CATAGARI")))

RANGE = FROM WHICH CELL TO YOU WANT TO APPLY THIS FORMULA TO TILL WHICH CELL.

CATAGARI = WHAT DO U WANT < FOR FOR FIRST > FOR SECOND

May 22, 2008 | Excel (SS8SATAS5128400R)

You probably want to use the LINEST function for straight lines or LOGEST for exponential curves.

In Excel 2007, there are a few tricks. One is to select a range of cells and enter your formula there. If you do not select a range of cells all the variables (coefficentis, R2, errors, etc) will not be dislayed.

The other tricks is one must hit Ctrl+Shift+Enter to display the results.

http://support.microsoft.com/kb/828533 is a link from Microsoft with a detailed explaination. Happy OLS regressing!

kpenguin

In Excel 2007, there are a few tricks. One is to select a range of cells and enter your formula there. If you do not select a range of cells all the variables (coefficentis, R2, errors, etc) will not be dislayed.

The other tricks is one must hit Ctrl+Shift+Enter to display the results.

http://support.microsoft.com/kb/828533 is a link from Microsoft with a detailed explaination. Happy OLS regressing!

kpenguin

May 13, 2008 | Microsoft Excel for PC

When i first figured out how to pull data from SQL and put the results in an excel file i referenced these two articles....

Reading and writing excel file using VB.NET (http://www.codeproject.com/KB/vb/Work_with_Excel__VBNET_.aspx)

Get the Values From DataBase and Stored into excell Sheet (http://www.codeproject.com/KB/vb/Getvaluesfromdatabase.aspx)

This is the code i ended up using.... (check out those links to see how you need to import the ms office excel reference file with visual basic)

Const stcon As String = "Provider=SQLNCLI;server=xxxxx;database=xxxxx;uid=xxxxx;pwd=xxxxx;DataTypeCompatibility=80"

Dim stSQL As String = "select * from scs_rate_class_money where irate_book = 124 and snew_used = 'U' and sclass = '2' and splan = 'T4' and sopt_code = 'F1'"

Dim cnt As New ADODB.Connection

Dim rst As New ADODB.Recordset

Dim fld As ADODB.Field

'Open the connection.

cnt.Open(stcon)

'Open the recordset.

With rst

.CursorLocation = ADODB.CursorLocationEnum.adUseClient

.Open(stSQL, cnt, ADODB.CursorTypeEnum.adOpenForwardOnly, _

ADODB.LockTypeEnum.adLockReadOnly , _

ADODB.CommandTypeEnum.adCmdText)

.ActiveConnection = Nothing 'Disconnect the Recordset.

End With

'Close the connection

cnt.Close ()

Dim exp As Export = New Export()

Dim xlApp As New Microsoft.Office.Interop.Excel.Application

Dim xlWBook As Microsoft.Office.Interop.Excel.Workbook = xlApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet )

Dim xlWSheet As Microsoft.Office.Interop.Excel.Worksheet = CType(xlWBook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet)

Dim xlRange As Microsoft.Office.Interop.Excel.Range = CType(xlWSheet, Microsoft.Office.Interop.Excel.Worksheet).Range("A2")

Dim xlCalc As Microsoft.Office.Interop.Excel.XlCalculation

Dim i As Short

'Turn off Excel's calculation.

With xlApp

xlCalc = .Calculation

.Calculation = Microsoft.Office.Interop.Excel.XlCalculation.xlCalculationManual

End With

'Write the fieldnames.

For Each fld In rst.Fields

xlRange.Offset(0, i).Value = fld.Name

i = i + 1

Next

'Populate the range.

xlRange.Offset(1, 0).CopyFromRecordset(rst)

'Close the recordset.

rst.Close()

'Make Excel available to the user.

With xlApp

.Visible = True

.UserControl = True

'Restore the calculation mode.

.Calculation = xlCalc

End With

'Release variables from memory.

fld = Nothing

rst = Nothing

cnt = Nothing

xlRange = Nothing

xlWSheet = Nothing

xlWBook = Nothing

xlApp = Nothing

Reading and writing excel file using VB.NET (http://www.codeproject.com/KB/vb/Work_with_Excel__VBNET_.aspx)

Get the Values From DataBase and Stored into excell Sheet (http://www.codeproject.com/KB/vb/Getvaluesfromdatabase.aspx)

This is the code i ended up using.... (check out those links to see how you need to import the ms office excel reference file with visual basic)

Const stcon As String = "Provider=SQLNCLI;server=xxxxx;database=xxxxx;uid=xxxxx;pwd=xxxxx;DataTypeCompatibility=80"

Dim stSQL As String = "select * from scs_rate_class_money where irate_book = 124 and snew_used = 'U' and sclass = '2' and splan = 'T4' and sopt_code = 'F1'"

Dim cnt As New ADODB.Connection

Dim rst As New ADODB.Recordset

Dim fld As ADODB.Field

'Open the connection.

cnt.Open(stcon)

'Open the recordset.

With rst

.CursorLocation = ADODB.CursorLocationEnum.adUseClient

.Open(stSQL, cnt, ADODB.CursorTypeEnum.adOpenForwardOnly, _

ADODB.LockTypeEnum.adLockReadOnly , _

ADODB.CommandTypeEnum.adCmdText)

.ActiveConnection = Nothing 'Disconnect the Recordset.

End With

'Close the connection

cnt.Close ()

Dim exp As Export = New Export()

Dim xlApp As New Microsoft.Office.Interop.Excel.Application

Dim xlWBook As Microsoft.Office.Interop.Excel.Workbook = xlApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet )

Dim xlWSheet As Microsoft.Office.Interop.Excel.Worksheet = CType(xlWBook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet)

Dim xlRange As Microsoft.Office.Interop.Excel.Range = CType(xlWSheet, Microsoft.Office.Interop.Excel.Worksheet).Range("A2")

Dim xlCalc As Microsoft.Office.Interop.Excel.XlCalculation

Dim i As Short

'Turn off Excel's calculation.

With xlApp

xlCalc = .Calculation

.Calculation = Microsoft.Office.Interop.Excel.XlCalculation.xlCalculationManual

End With

'Write the fieldnames.

For Each fld In rst.Fields

xlRange.Offset(0, i).Value = fld.Name

i = i + 1

Next

'Populate the range.

xlRange.Offset(1, 0).CopyFromRecordset(rst)

'Close the recordset.

rst.Close()

'Make Excel available to the user.

With xlApp

.Visible = True

.UserControl = True

'Restore the calculation mode.

.Calculation = xlCalc

End With

'Release variables from memory.

fld = Nothing

rst = Nothing

cnt = Nothing

xlRange = Nothing

xlWSheet = Nothing

xlWBook = Nothing

xlApp = Nothing

Jan 03, 2008 | Computers & Internet

Dear Madiha35,

I would recommend the use of the Table Function in Excel.

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

Step 1: Enter your data into the worksheet.

Step 2: Create Table

Highlight the relevant data

On the insert tab, click on Table

Step 3: Verify Table range is correct, Click OK

Step 4: Select the cell you where you wish to Sum Data.

Click on Autosum.

Step 5: To Insert new data

Click on the sum row in the table, (Not the entire worksheet row)

Right click, Insert, Insert Table rows from above

Step 6: Enter new data in row

Step 7: Data is automatically calculated in formula.

Oct 22, 2007 | Computers & Internet

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

122 people viewed this question

Usually answered in minutes!

×