Question about Microsoft Business & Productivity Software

The DSUM function is very useful, but it does use a lot of processing. Every DSUM function does a scan of every row of your table. There are a few ways you can reduce computing time.

First (and the most obvious) is to reduce the number of DSUM functions or reduce the size of your table. I presume you have already tried this.

Secondly consider using Pivot Tables to do the task, or to reduce the size of your table. There is a Pivot Table wizard under the Data menu. It's a fairly user friendly feature of Excel, so I suggest you try it out on your table. Pivot tables will be many times faster than DSUM functions because they only scan the table once. There are some tutorials available on the internet.

Third, if your DSUM functions are only summing one value in the table, then it would be much quicker if you can sort the table on the lookup value (or criteria). Then use LOOKUP, VLOOKUP or MATCH functions to find the value you're looking for. On a sorted table, these functions are many times faster that DSUM functions.

I hope this helps a little. It's hard to diagnose without seeing the spreadsheet and knowing the details of the problem you are trying to solve.

First (and the most obvious) is to reduce the number of DSUM functions or reduce the size of your table. I presume you have already tried this.

Secondly consider using Pivot Tables to do the task, or to reduce the size of your table. There is a Pivot Table wizard under the Data menu. It's a fairly user friendly feature of Excel, so I suggest you try it out on your table. Pivot tables will be many times faster than DSUM functions because they only scan the table once. There are some tutorials available on the internet.

Third, if your DSUM functions are only summing one value in the table, then it would be much quicker if you can sort the table on the lookup value (or criteria). Then use LOOKUP, VLOOKUP or MATCH functions to find the value you're looking for. On a sorted table, these functions are many times faster that DSUM functions.

I hope this helps a little. It's hard to diagnose without seeing the spreadsheet and knowing the details of the problem you are trying to solve.

Oct 23, 2009 | Microsoft Office Excel 2003 for PC

Hello this is Baris,

First off all when you say hypotinuse I think it is a 90 Degree triangle. Total of the angles off a triangle is 180 degree. So it is a simple algebra question.

Hypotinuse is 90

Right angle is R

Left angle is L

Total is 180

Equation is 90+ R +L = 180

We are looking for R, so lets arrange our equation.

R= 180 - 90 - L

R= 90 - L

This is our formula for excel

Lets put it in the excel

Type in A1 "hypotinuse "

Type in A2 "Left Angle"

Type in A3 "Right Angle"

Type in B1 90

Type in B2 "whatever the value given for the left angle"

Type in B3 =90-B2

As soon as you change the value in the cell B2, B3 will change by itself. Hope this helps :)

First off all when you say hypotinuse I think it is a 90 Degree triangle. Total of the angles off a triangle is 180 degree. So it is a simple algebra question.

Hypotinuse is 90

Right angle is R

Left angle is L

Total is 180

Equation is 90+ R +L = 180

We are looking for R, so lets arrange our equation.

R= 180 - 90 - L

R= 90 - L

This is our formula for excel

Lets put it in the excel

Type in A1 "hypotinuse "

Type in A2 "Left Angle"

Type in A3 "Right Angle"

Type in B1 90

Type in B2 "whatever the value given for the left angle"

Type in B3 =90-B2

As soon as you change the value in the cell B2, B3 will change by itself. Hope this helps :)

Sep 27, 2009 | Microsoft Excel for PC

Try this formula=((A1)*(1+A2))-A3
Where:
A1 is the original Balance
A2 is the interest rate
A3 is the money paid for the preceding month

Apr 02, 2009 | Microsoft Excel for PC

To calculate the difference in Years use =Year(c,r)-Year(c,r)

To calculate the difference in Months use =Month(c,r)-Month(c,r)

To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

To calculate the difference in Months use =Month(c,r)-Month(c,r)

To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

Mar 15, 2009 | Microsoft Office Excel 2003 for PC

Assuming you put the start date in cell A1, put this formula:

=DATE(YEAR(A1),MONTH(A1)+15,DAY(A1))

in the cell where the result wanted to be appeared.

P.S.: If this information was helpful, please rate this solution.

=DATE(YEAR(A1),MONTH(A1)+15,DAY(A1))

in the cell where the result wanted to be appeared.

P.S.: If this information was helpful, please rate this solution.

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

use the below formula to get the date of the LWD (Monday thru Friday) of the month.

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Jan 30, 2009 | Microsoft Excel for PC

Let's start with the 1st equation. I assume you want to be able to recalculate by changing the number of pages.

Put 65 in cell a1.

360 in b1

In C1, put the formula =a1/b1 that's your book thickness

In D1, put .02 for the cover

In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Put 65 in cell a1.

360 in b1

In C1, put the formula =a1/b1 that's your book thickness

In D1, put .02 for the cover

In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Jul 14, 2008 | Business & Productivity Software

Okay, here's a possible solution--based on my interpretation of your problem.

Suppose you have some value in cell B1, and the month (either Jan, Feb, or Mar) is stored in cell A1. The formula in C1, which performs calculations based on which month appears in A1, is as follows:

=IF(A1="Jan",B1*0.25,IF(A1="Feb",B1*0.3,IF(A1="Mar",B1*0.4)))

In this example, the value in B1 is multiplied by .25 if the month is Jan, by .3 if it's Feb, and .4 if it's Mar.

Suppose you have some value in cell B1, and the month (either Jan, Feb, or Mar) is stored in cell A1. The formula in C1, which performs calculations based on which month appears in A1, is as follows:

=IF(A1="Jan",B1*0.25,IF(A1="Feb",B1*0.3,IF(A1="Mar",B1*0.4)))

In this example, the value in B1 is multiplied by .25 if the month is Jan, by .3 if it's Feb, and .4 if it's Mar.

Nov 09, 2007 | Business & Productivity Software

Microsoft Equation is an optional component and is not automatically installed. To install Microsoft Equation, you have to run the Office Installer, and select Custom Installation. The installation wizard will present you with the optional components to install. Find Microsoft Equation, and make sure the Run this in my computer option is selected. Then continue with the installation. Office will configure itself to include the Microsoft Equation program.

Sep 21, 2007 | Microsoft Office Standard for PC

68 people viewed this question

Usually answered in minutes!

×