Question about The Computers & Internet

# How to keep a cell value constant?

Suppose I want to divide the numbers in a sequence of cells by a number in a particular cell, how to keep the value in that particular cell as constant in the formula used?

Posted by on

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

You have to use the sign \$ example: if the cell that you want to keep is A5 in the formulas you have to write \$A\$5 it keep that cell as constant in all formulas.

Posted on May 19, 2017

• magelp May 19, 2017

you have to use the sign \$ example: if the cell that you want to keep is A5 in the formulas you have to write \$A\$5. when you copy the formula, it keeps that cell as constant in all formulas.

×

Hi,
A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### Cell number sequence

Sequencing is a formula =A1+1. If you insert a cell you can re-s
equence by doing a autofill in the column that contains the sequence number.
i.e.
Cell A1 value= 1
Cell A2 =A1+1 (value will be 2)
If you auto-fill the entire column will sequence:
=A2+1 (value will be 3)
=A3+1
etc.

Jul 03, 2017 | The Computers & Internet

### What is formula to find percentage of females in my workplace?

To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

### How to do percentages in Excel - Office Blogs

https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
Feedback

### How to Calculate Percentages in Excel

www.excelfunctions.net > Excel-Formulas
Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

### Excel formula: Get percentage of total ' Exceljet

https://exceljet.net/formula/get-percentage-of-total
Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

### Wrong exponential value

Sorry, but there is nothing wrong with the exponential notation on your calculator. There is however a misunderstanding from your part on the priority rule of operations.
The sequence 0.030377/6.022x10^23 is interpreted as (0.030377/6.022)x10^23 while you wanted 0.030377/(6.022x10^23), dividing by Avogadro's Number.

How to fix it. Enter the power of 10 exponent (10^23) using the EE key. In other words Avogadro's Number should be typed in as 6.022 [EE]23. If you do not have the EE key you must use parentheses to enclose the whole number (6.022x10^23) or use the division key twice /6.022/10^23
On a calculator a sequence a/bxc where both operations have the same level of priority is executed from left to right.

Nov 03, 2012 | Texas Instruments BA-II Plus Calculator

### I am trying to divide a power of 10 by and another number to a neg power of 10

For integer powers of 10 you can use the EE shortcut. [2nd][,] displays E.
For non-integer values of the exponent (such as -5.34) you must use the key sequence [2nd][LOG] (10^x) then enter your negative non-integer exponent.

Jan 16, 2012 | Texas Instruments TI-84 Plus Silver...

### I get an error when I tally cells that have errors because of dividing empty cell by empty cell.

Hi I dont really have much to do with Excel as I essentially build and repair and install, gosh I still type with two fingers!! Now below I have provided a link to Microsoft . Ways to count values in worksheets etc. If the problem persists try to update Office with what ever sercice packs are required and see if this helps. the link is http://office.microsoft.com/en-au/excel-help/ways-to-count-values-in-a-worksheet-HA010287849.aspx and I do hope it helps.
Cheers

Oct 28, 2011 | Microsoft Excel for PC

### This is so easy but I've forgotten. I have an old manual Casio caluculator. I just want to divide a series of numbers by 4. I can't seem to figure out how to do it. Any ideas? Thanks, Julia

If your calculator has the capabilities to do constant calculations here is how you perform calculations with a constant.

1. Enter the constant (4)
2. Press the operation key (/) once.
3. Press the operation key (/) a second time.
4. Your calculator may show a k in its display (LCD)
5. To divide a number by 4, enter the number and press =
6. To divide another number by the constant (4) , Enter the number and press =
7. Keep entering the dividends and pressing =
I hope it works for you.

Oct 01, 2010 | Office Equipment & Supplies

### Microsoft excel

this is done through formulas. You write them in relationship to one another. Say you put a value into B1 then you write a formula for c2 like =SUM(A1/2)which means the sum of A1 divided by 2. or you can say make a formula that is like this =SUM(A1/C1) which means the value of A1 divided by the value of C1.

Jan 10, 2009 | Computers & Internet

### Excel and the AVERAGE function

Here is one way:

In this example, my numbers are in cells a1 through a4. My average is computed with the formula:

=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")

I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.

Dec 30, 2007 | Computers & Internet

### Excel

suppose ur number is at cell B2 with any value. lets say u want formula in A3. then A3 =*b2*3/4 to round back the A3 to full number the simpliest solution is to change cell formatint to NUMBER and set the decimal places to 0.

Sep 17, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

19 people viewed this question

Level 1 Expert