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

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.


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


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


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.


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.


When cell C3 containing the formula B6C8 is copied to cell D2 the formula in cell D2 is?

When cell C3 containing the formula B6C8 is copied to cell D2, the formula in D2 will adjust based on its new location. It will become C6D8, as Excel automatically updates the cell references relative to the position of the new cell. This is known as relative referencing.


How can I find my h-index on Google Scholar?

To find your h-index on Google Scholar, you can create a Google Scholar profile and it will automatically calculate and display your h-index based on your publications and citations.