Microsoft Office Tutorials and References
In Depth Information
Important Tools for Any Business
When regions aren’t able to sell the product, you would only want the average of the positive
cells rather than an average that includes regions that have not selected it. Using the SUM , IF ,
and COUNTIF functions in the form of an array will average just the positive cells. Notice the
example in Figure 2.19.
Average only positive
cells for a more
International Rate Converters
If you have to deal with international currency rates from countries around the world, it’s good
practice to build currency converter tables. You can create a database for each countr y or a
database combining the countries and then extracting the countr y and currency and applying
the rate against a US dollar table. The example in Figure 2.20 illustrates three countries with a
fictitious currency rate along with the formula in the converter table to convert all currencies
into US dollars.
The new Euro symbol first appeared in Excel 2000. It is unavailable in previous Excel
tables to convert
to US dollars.