Say your prices are in A1-A500. In B1 paste the formula above. Now copy that cell, B1, and paste it down to B500. Once pasted, the formula will adjust to the corresponding cells. Just make sure you modify the original formula to reflect the cell with your price, if it isn't already A1.
Using that big array constant as the lookup table can be confusing, so I usually recommend setting up a lookup table on another worksheet. So, if you have a worksheet named Lookup, you could enter these in A1:B5...
thanks Matt, but I don't understand anything about Excel or formulas, and don't really know how to use that.
>> In B1 paste the formula above. Now copy that cell, B1, and paste it down to B500.
There is a field in B1 already. The next empty field is CY1.
I tried selecting that column range and pasting the formula but it give a message saying "the clipboard is larger . . ".
Once you do that, select the cell where you entered the formula, and hit Ctrl+C to copy. Now select the range you would need to copy that formula to, and hit Enter.
thanks Matt, . . that worked but put the new values into the CY column.
I need the original prices that are in E2 - E500 changed. They are still displaying the original value.
The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
=IF((A1*1.18)-INT(A1*1.18)
Flyster