0
How can you use the IF function and absolute reference to calculate the amount to be placed in a cell?
Wiki User
∙ 11y ago
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
There are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoThere are a variety of ways of doing it, so it would depend on the particular action you are trying to do So to take a completely random example, if you wanted say to add 10 or 20 to a value, depending whether it was under 50 or not, then you could do something like this where A5 is where the 10 is and A6 is where the 20 is and B7 is the cell you are checking:
=IF(B7<50, B7+$A$5, B7+$A$6)
That formula could then be copied. As you did so the reference to B7 would change, but the references to A5 and A6 would not. You could have a list of values, starting at B7, with the next in B8 and so on and have the first formula in C7 and then C8 and so on as it was copied.
Add your answer:
Earn +20 pts
Is there any shortcut function to match positive amount with Negative amount in Excel 2007?
=-b7 where b7 is an example cell reference. The result will be the negative of whatever is in b7.
When a car is said to be driving on the highway at 70 mph what frame of reference is used to calculate that speed?
Distance that can be traversed at that speed in that amount of time.
What is the reference point of gravitational potential energy?
Any point can be used as reference point, since the absolute amount of potential energy doesn't have any meaning; only the relative amount (i.e., increase or decrease between two positions) has. Quite often, one of the following standards is used: 1. For calculations near Earth's surface, the reference point is the floor. However, you can use any other reference point if it makes your calculations easier. 2. For astronomical calculations, the reference point is at an infinite distance. Thus, all potential energies have negative values.
What is the Differences between absolute frequency and relatative frequency?
The absolute frequency is the total amount of occurances of one variable. The relative frequency is the absolute frequency divided by the total amount of occurances of ALL variables.
How to you calculate bank guarantee amount?
To calculate the bank guarantee amount the amount of deposit in the bank account is usually considered.
The beginning amount used to calculate interest?
it is the principal amount... i.e., the amount for which u have to calculate the interest Enjoy!! Kush
How do you calculate the amount of over or underapplied overhead?
how do you calculate the amount of the over-or under applied factory overhead?
Does absolute humidity increase if the amount of water vapor in the air remains unchanged?
No, absolute humidity is the exact amount of water vapor in the atmosphere. So, if the water vapor in the air remains unchanged, so does the absolute humidity.
How do you calculate percent abundance for silicon?
You calculate the total amount of whatever it is that you want to find the silicon abundance for. Then you calculate the amount f silicon in that. Then percentage abundance of silicon = 100*amount of silicon/total amount Typically the amount would be measured as the mass.
Excel uses a technique called to keep a cell reference constant when copying a formula or function?
The example below shows a formula being created to work out the amount of discount each order would receive. The order totals are in column F and the discount rate is in B13. The initial formula has therefore been set up as: =F2*B13 The formula will generate a result for the first order. However, when copied, you will get zeros against the discount amounts for the other orders. This is due to the relative referencing that Excel applies to all formulae by default. Having copied the above formula, if you clicked on any formula in the Discount amount column below the first one, you would see that Excel has updated the references (=F3*B14, F4*B15). This is where the problem lies - you want Excel to change the first reference as your formula needs to refer to the different order totals, but the discount rate should remain constant. You need to make that reference absolute. F To make a reference absolute: Keyboard · Move to the cell where you have typed the formula and press [F2] to access Edit mode. · Move the cursor with the arrow keys so that it is next to the reference we want to fix. · Press [F4]. Dollar signs will appear against the column letter and the row number. · Press [ENTER] to confirm the change. In our example, amending the formula to read: =F2*$B$13 would prevent Excel from changing the B13 reference when the formula is copied. Fill handle You can get the fill handle to fill formulas down to the same level as the entries in the previous column by double-clicking on it. Pressing [F4] repeatedly over a reference allows you to toggle between making both the row and column absolute ($A$1), just the column absolute ($A1), just the row (A$1), or nothing absolute (A1).
Why Potential energy of an object at the earth's surface is not zero?
It may, or may not, be zero, depending on what you use as the reference level. The absolute amount of potential energy is physically meaningless; what matters is a difference in potential energy between two points.
Which adjustment function will enlarge an image by changing the amount of data stored in it to prevent distortion?
Any function that uses interpolation or extrapolation to calculate additional data points. You still won't be able to see through that dress though dude.
