answersLogoWhite

0

I believe you are referring to a macro.

Could also be an IF statement.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Can You can add formulas to a table to automatically calcuate amounts in word 2016.?

Yes, you can add formulas to a table in Word 2016 to automatically calculate amounts. To do this, place your cursor in the cell where you want the result, go to the "Layout" tab under "Table Tools," and click on "Formula." You can then enter a formula using standard mathematical functions, and Word will calculate the result based on the data in your table.


How do you make an amortization table fill automatically based off information in a single cell Like when you enter time on a mortgage calculator and each months information automatically fill?

You need to have formulas in the cells that use a reference to the single cell you are changing. You can use an absolute reference for the cell in the formulas. Then when you add or change a value in the cell, the table will automatically update itself based on the cell you have changed.


When changing data that is included in a formula you must do what to the data so that the formula will update?

You should put the data into cells and use cell references in the formula. Then when the data changes, the formula will automatically recalculate based on the current data.


In a spreadsheet Can a variable be changed?

Yes, in a spreadsheet, a variable can be changed by editing the cell that contains it. This can be done manually by typing a new value or by using formulas to update the variable based on other cell values. Additionally, if the variable is part of a formula, changing any referenced cells will automatically update the result.


What are some alternative options for infant formula for babies with soy allergies, such as non-soy infant formula?

Some alternative options for infants with soy allergies include non-soy infant formulas, such as those made from hydrolyzed protein or amino acid-based formulas. These formulas are designed to provide necessary nutrients for babies who cannot tolerate soy-based formulas. It is important to consult with a healthcare provider before making any changes to an infant's diet.


How does a crawler based engine work?

crawler based search engines such as google create their listings automatically, they "crawl" or "spider" the web, then people search through what they have found by dwc year 8d


What are the benefits of using formulas in excel especially for a lot of data?

The basic idea of formulae is that when the numbers on which a formula is based change, the formula is automagically recalculated. You can have a long series of calculations, each of which depends on earlier results.


How do i copy data from one excel sheet to another automatically?

To automatically copy data from one Excel sheet to another, you can use formulas or Excel's built-in features. For example, you can use the =Sheet1!A1 formula in the target sheet to reference a specific cell from the source sheet, allowing it to update dynamically. Alternatively, you can utilize Excel's Power Query feature to import and transform data from one sheet to another automatically. For more complex automation, consider using VBA macros to copy data based on specific conditions or triggers.


How do I sort formula based values in Excel?

Copy the formulas and in the column next to them, use the Paste Special option and choose values. It will put the actual values into the cells. You can then sort your data based on the column of values.


What are some alternative options for non-soy, non-dairy formula for infants with dietary restrictions or sensitivities?

Some alternative options for non-soy, non-dairy formula for infants with dietary restrictions or sensitivities include hypoallergenic formulas made from hydrolyzed proteins, amino acid-based formulas, and plant-based formulas such as those made from rice, coconut, or almond milk. It is important to consult with a healthcare provider or pediatrician before making any changes to an infant's diet.


What are the different types of baby formula available?

All baby formula attempt to replace breast milk. Some special kinds of formula are available if the baby has special dietary requirements. Basic milk based formulas are made from cow's milk. For those babies who are lactose intolerant, special cow's milk formulas are available. Soy milk formulas can be substituted both for lactose intolerant babies, or for babies who are raised to be vegan. The doctor may prescribe yet other specialty formulas for babies that do not tolerate soy or milk products.


Which formula is likely to be INCORRECT?

To determine which formula is likely to be incorrect, one would need to evaluate each formula based on its context and application. Common sources of error include incorrect variable relationships, inappropriate units, or misapplication of mathematical principles. Without specific formulas presented, I cannot identify which one may be incorrect. Please provide the formulas in question for a more accurate assessment.