answersLogoWhite

0


Best Answer

If a formula is in a cell and a number is entered into the same cell, then the formula will be gone and replaced by the number. You can enter a number in a cell that is referenced by a formula in another cell. The cell with the formula in it will update when the number is entered into the other cell. Say you change the value in A2 and the cell A3 contains the formula:

=A2*10

Then the total in A3 will update when any change in A2.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Is it possible to insert a number into a Microsoft excell cell with a formula already in the cell automatically generating an answer without having to write the formula everytime?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is it possible to copy from Microsoft Word to Microsoft Excel?

=It can be possible most of the time it is..=


Generating multiple possible answers to a problem illustrate?

Componential/Analytical intelligence


Is it possible to download Microsoft Word 2007 independently from the Microsoft Office Suite?

It is possible to download Microsoft Word 2007 without having to download the entire Office Suite. Word 2007 can be purchased individually from the Microsoft website.


Why jaguar sunroof won't close automatically?

It is possible that the sunroof motor needs to be replaced if the sunroof is not closing automatically. It is also possible that the wiring needs to be replaced.


Does Microsoft have child labor and sweatshops?

One of its contractors does or did, i think Microsoft dealt with it but it is possible that they didnt.


What sentence best describes clustering?

You're generating words that suggest possible sentences or paragraphs.


What is the meaning of wavy red line and wavy blue line?

When you automatically check spelling and grammar, Microsoft Word uses wavy red underlines to indicate possible spelling errors and wavy green underlines to indicate possible grammatical errors.Blue wavy underlinesWord uses wavy blue underlines to indicate possible instances of inconsistent formatting.


Can we play stick arena on your Wii?

It is possible, IF your Wii doesn't run out of memory everytime it tries to load.


What is the mission and vision statements of Mrs Fields Cookies?

To produce the best quality product possible everytime.


Is it possible to make 3ds Max save textures and bitmaps automatically with the Max files?

no,it is not possible


Can you create separate files in MS Word Documents for entries in an Excel spreadsheet?

Microsoft Word and Microsoft Excel documents can be linked to each other, so that changes in one document will show up in the other. So it is possible to enter data in Microsoft Word and have it appear in Microsoft Excel. It is also possible to do formulas in tables in Microsoft Word, without linking to Microsoft Excel.


Is it possible to teach your guppy fish tricks Which tricks and how can you teach them?

Well I have a goldfish and what i do is like make some noise everytime it swims up to get food. Then now everytime i do that action it swims up and follows my hand.