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

thanks in advance - ernie

- The cell currently being evaluated contains a constant
- Cell Being Evaluated Contains a Constant
- The cell currently being evaluated contains a constant
- Copy a formula maintaining a constant cell
- How do I delete a constant in a merged cell?
- Retyping the entire formula:Editing countif formulae
- Editing countif formulae
- Holding a Cell In a Constant Location without Locking
- Changing formula result to constant value
- Using name formulas as a series in pie graph
- Detect If Cell Contains A Formula Or Constant
- Looking for formula: replace cell a1 with cell b1 if cell b contains a value
- Looking for formula: replace cell a1 with cell b1 if cell b contains a value
- Adding a field to a table that contains a formula
- Mark font red when cell contains a formula
- Formula to ID cells containing a formula
- Button that contains a formula result
- How to determine whether a cell contains a formula
- Dragging formula where there is a constant
- Formula to find out if this cell contains (a part of) this string
- '=AND' Formula with a 'Contains" Statement?
- Conditional Format if a cell contains a formula
- Detect if a cell contains a value or calculation/formula
- Hide formula contained in a cell

"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 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

"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

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.

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.

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

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

Thanks! Patience

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!

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.

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

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 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'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 = ActiveCellIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

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

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

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?

Thanks

Emilio

Thanks in advance

******** ******************** ************************************************************************>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.

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

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

Thanks

Peter

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.