Question about The Computers & Internet

1 Answer

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

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 16 Answers

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.

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

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

2 Answers

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

1 Answer

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

1 Answer

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

2 Answers

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

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

19 people viewed this question

Ask a Question

Usually answered in minutes!

Top The Computers & Internet Experts

Carl Rick

Level 2 Expert

74 Answers

colinat108

Level 2 Expert

232 Answers

Are you a The Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...