Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

formula containing a constant

I want to write a formula that will allow me to only have to enter a number but will multiply that number by a constant. example - enter the number 450 to be multiplied by 1.05 and the cell results = 472.5.

thanks in advance - ernie


Post your answer or comment

comments powered by Disqus
Excel generates the message:
"the cell currently being evaluated contains a constant"
and then does not evaluate a formula. The same formula, character for
character, works fine in a different workbook. I can find no differences
between their properties.
1) Does anyone know what causes this?
2) Does anyone know why there is no reference to this message in any
Microscoft help or assistance, although the message is generated by Excel?
Thanks,
Barrie

Hello,

I know enough about excel to be dangerous. The issue I have is I have created a worksheet that references another workbook and worksheet. It has been working fine until now. I had to insert a new row and copy the formula from the cell above down to the cell in the new row. This works fine until I need to change the referenced cell i.e. "sheet1!A1" to "sheet1!A4". I hit F2 to edit the cell number, I change A1 to A4 hit enter and instead of it referencing the information from the "sheet1!A4". The formula shows up. So I went to Tools then Formula Auditing then Evaluate Formula it tells me that "The Cell Currently Being Evaluated Contains a Constant"

Like I said I know enough about Excel to screw things up. I would appreciate your help

Excel generates the message:
"the cell currently being evaluated contains a constant"
and then does not evaluate a formula. The same formula, character for
character, works fine in a different workbook. I can find no differences
between their properties.
1) Does anyone know what causes this?
2) Does anyone know why there is no reference to this message in any
Microscoft help or assistance, although the message is generated by Excel?
Thanks,
Barrie

I'm wanting to copy a formula down a list of cells i.e. =SUM(G7*100)/G101
updating the first cell (G7) to the next (G8) and so on while keeping G101
constant throughout. I seem to recall the use of the $ sign but it's slipped
my mind how to do it.

I am attempting to type a paragrah within a merged cell and although some of
the text will wrap automatically, not all of it will. I'm getting a message
saying that this cell contains a constant and I want to delete it so that my
text will all wrap to the next line automatically. PLEASE HELP! Thank you.

Dean,

Can you post a copy of your formula?

Knightly

Dean F Wrote:
> Hi - When I finish editing a formula containing a countif calculation,
> it
> changes from a formula to a regular cell, despite the '=' and I get a
> message
> that my formula contains a constant. The formula reads exactly as a
> working
> one below, and I can't seem to get it to work, even retyping the
> entire
> formula. The countif reference is to another sheet in the workboow.
>
> Thx
>
> Dean

--
sirknightly

Hi - When I finish editing a formula containing a countif calculation, it
changes from a formula to a regular cell, despite the '=' and I get a message
that my formula contains a constant. The formula reads exactly as a working
one below, and I can't seem to get it to work, even retyping the entire
formula. The countif reference is to another sheet in the workboow.

Thx

Dean

I need to hold a formula in a constant location (say cell M5) after having deleted columns preceeding that column (say I delete columns A-E). Is this possible? Thanks...

What's the quickest, easiest way to convert the result of a formula into a constant? For examply, I used the proper command to change fields of data to title case. Now I need to do a mail merge, and I want to change the fields so that the title case data is a value, rather than still being the formula.

Thanks! Patience

Howdy everyone. Apologies if this question is rudimentary--I've done a few searches and haven't found anything resembling the solution I'm after. Anyway...

I'm using Excel 2003. I have several names which are actually formulas. Ex:Sheet1.xls!PercentA = SUM((C15+F15+I15)/(C18+F18+I18))
Sheet1.xls!PercentB = SUM((C16+F16+I16)/(C18+F18+I18))
Sheet1.xls!PercentC = SUM((C17+F17+I17)/(C18+F18+I18))When I throw these into cells using "=PercentA" they're fine by themselves but I would like not to have them in cells at all.

I'd like the names to be part of a pie chart, but if I enter the series as:=Sheet1.xls!PercentA,Sheet1.xls!PercentB,Sheet1.xls!PercentCI get: "A formula in this worksheet contains one or more invalid references. Verify that your formulas contain a valid path, workbook, range name, and cell reference."

Any help getting this squared away would be greatly appreciated.

Thank you!

I need an equation that lets me determine whether a cell contains a static constant value (either a string or a number), or an equation that generates a value.

Problem: I have a cell that contains a default equation that generates a default value, depending on a few conditions. The user can overwrite this cell with a constant. In another cell I need to know whether that cell is still the default equation or a new constant value.

I cannot simply test the value of the contents to see if they match my default, because the user may choose to enter that value.

Any help you can provide would be appreciated! Thanks in advance.

Column A contains names and column B contains names too, but many cells in column B are also blank.

If cell A1 contains a name, for example and cell B1 contains a name, then replace the name of cell A1 with the name of cell B1; otherwise do not replace cell A1 name if cell B1 is empty.

Use this for formula for the whole of column A.

thanks

Column A contains names and column B contains names too, but many cells in column B are also blank.

If cell A1 contains a name, for example and cell B1 contains a name, then replace the name of cell A1 with the name of cell B1; otherwise do not replace the name in cell A1 if cell B1 is empty.

Use this for formula for the whole of column A.

thanks

I have 3 columns (Fields) and I wanted to add a 4th that is based on a formula that analyzes data in column C.

I have it done this in excel and double click the fill handle to copy the formula down the range but now that my data has exceeded the 65k limit i had to move it to Access...And I havent come across anything that allows me to add an etxtra feild that contains a formula, I need this columns result in order to run some other formulas...is this possible??

I'm trying to write some code for marking a cell's font red if it contains a formula and marking it black if it doesn't.

I've come up with the following, but it doesn't work. Can anyone help?

Many thanks
Pete

	VB:
	
 Range 
If OldCell.Find("=") Is Nothing Then 
    OldCell.Font.ColorIndex = 3 
Else: OldCell.Font.ColorIndex = 0 
End If 
Set OldCell = ActiveCell 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


I need to identify cells that contain a formula so I can use conditional formatting to colour those without formula.

Most cells in my array contain a formula but occasionally I have to over write the result or enter a result manually because a vlookup is returning an error.

Type, find etc can't do it.

cheers
ziggy

Greetings,

Have found this site useful, but have never posted.

I would like to have a button contain a formula result that will run a macro when clicked, is that possible?

I have an inventory sheet that I want to be able to click the button that shows the number of each item that was delivered (ie 24) that will take me to the Delivery sheet and to the item row (via macro) so I can check items that are 'out of wack'

Thanks,

Craig

Excel 2002

I have inherited a spreadsheet which has been incorrectly updated by a co-worker.

In this spreadsheet there are two related sheets. The first sheet is an input sheet and contains a series of grouped statements regarding projects. These are listed in column B. Row 1 columns C to xlend contain project titles.

The idea is that for every project listed in row 1 an 'x' is input in the corresponding column against each statement in column B if it applies to the project in question.

The second sheet maps all the input cells in the first sheet with a formula which results in a value if an 'x' appears in the corresponding cell on the first sheet. In this way all the column values are added and each project ends up with a 'score'.

Unfortunately, when my co-worker was given the spreadsheet to update, instead of updating the input sheet, he overwrote the sheet containing the formulas with the values that the formulas would have calculated if he had updated the input sheet!

I have now been given the task to undo all the damage my co-worker has inflicted, to reinstate the formulas and to update the input sheet instead.

I thought I would be able to identify those cells containing numerics instead of formulas using the TYPE function, but of course, TYPE works on the result of any formula, and doesn't return any indication that a formula exists.

What I want to do is to run a macro which examines each cell in the array and identifies those cells that don't contain a formula. These will be added to a temporary sheet which will become the input to another macro which will update each cell listed on the input sheet with an 'x'. I can then reinstate the formulas on the second sheet.

I have searched for a function which will differentiate between cells containing formulas and values, but to no avail.

Can anyone out there give me a solution?

Quick question. Hopefully it's an easy one for most others. Basically, I've entered a simply formula where individual cells in a row are being divided by a constant (same cell). This doesnt allow me to drag the formula across the entire row. When I do it causes a "#DIV/0!" error. I've been looking at this for too long. I'm pretty sure there's a way to drag this formula across the row when one of the cells is constant, no???

Thanks

Emilio

Can anybody help me with a formula to find out if a cell contains (a part of) a string ?

Thanks in advance

Hello. I have a worksheet in which I'm trying to add an =AND in Col F that would return "Modify to 40X48" if Col A contains a "#" and if 40>Col D>38.5 and if 48>Col E>46. I'm reasonably sure I could get the dimensions to return what I want but can I also include the search for # in Col A?

******** ******************** ************************************************************************>Microsoft Excel - Bad_pallets.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=
ABCDE1sku*pkg*uom2*wid2*dpth22Q5954A#AK2*PL39.547.53Q2458AR#ABA*PL39364C4791A*PL39.439.45Q7494V#ABA*PL39466Q1860A#AK2*PL31.547.37Q6455A#881*PL38.347.38Q7494AR#ABA*PL39479C7059A#ABM*PL39.447.210C7061A#ABB*PL394711C7061A#AKV*PL39.447.2Sheet1*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Hi All,

I have a spreadsheet that contains a formula that returns a value based on data contained in another cell. There are sometimes exceptions to the rule, so users can manually input data. I would like to see what cells have formulas and what cells don't.

Is it possible to conditionally format a cell if it contains a formulas.

Thanks,
Damien

Hi

I was wondering whether there is a way in VBA to detect if a cell contains a value or calculation/formula?

Thanks
Peter

Hi all,
I have a worksheet in which one particular cell contains a certain formula. For security reasons, I wish to hide the FORMULA contained in the cell. However, the VALUE of the cell given by the above formula should always remain displayed for the user.
I want this to be done only for that particular cell. I tried hiding the formula bar,but it hides it for all cells.

Any idea how this can be done?

Thanks in advance,
Nachiket Pendharkar.


No luck finding an answer? You could always try Google.