Question about Microsoft Office Professional 2007 Full Version for PC

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.

Thanks

Tim

Thanks

Tim

Sep 26, 2010 | Microsoft Excel for PC

Assuming the cell that you want to "test" is B1, the formula is:

=IF(WEEKDAY(B1,1)=7,TODAY()+2,TODAY()+1)

If this solves your problem, please rate me, thanks.

=IF(WEEKDAY(B1,1)=7,TODAY()+2,TODAY()+1)

If this solves your problem, please rate me, thanks.

Apr 05, 2009 | Microsoft Excel for PC

Use the IF and Date functions together. On sheet 3, put the birthday (3/15/1954) in cell B1, put the beginning date (1/1/1946) in cell C1 and the ending date (12/31/1964) in cell D1.

Then on Sheet 1, but the following formula in the cell you want an X to be placed in.

=IF(AND(Sheet3!B1>=Sheet3!C1,(Sheet3!B1<=Sheet3!D1)),"X"," ").

Make sure you type the formula Exactly as it appears.

Then on Sheet 1, but the following formula in the cell you want an X to be placed in.

=IF(AND(Sheet3!B1>=Sheet3!C1,(Sheet3!B1<=Sheet3!D1)),"X"," ").

Make sure you type the formula Exactly as it appears.

Mar 20, 2009 | Oracle Database Enterprise Named User Plus

The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:

=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Computers & Internet

Here is one way to do it:

1. In column A enter the name

2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)

3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)

4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)

5. In column E, put this formula:

(D2/30)*1.25 (assuming this is line 2)

You can then copy these lines as many times as you need to, total them, etc.

1. In column A enter the name

2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)

3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)

4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)

5. In column E, put this formula:

(D2/30)*1.25 (assuming this is line 2)

You can then copy these lines as many times as you need to, total them, etc.

Dec 27, 2008 | Microsoft Office Standard for PC

Are you trying to figure the difference in days between these dates and one single date (Dec. 31, 2008 for example)?

Whatever you're trying to do, here is the formula, assuming you're starting in A1:

Put the first date in the format Day-Month-Year in numbers (Sept. 3 is 03-09-2008)

Then put your other date in B1, in Day-Mo-Yr format (31-12-2008 for Dec. 31, 2008)

In C1 put B1-A1 and that will give you the number of days between those two dates.

Whatever you're trying to do, here is the formula, assuming you're starting in A1:

Put the first date in the format Day-Month-Year in numbers (Sept. 3 is 03-09-2008)

Then put your other date in B1, in Day-Mo-Yr format (31-12-2008 for Dec. 31, 2008)

In C1 put B1-A1 and that will give you the number of days between those two dates.

Dec 27, 2008 | Microsoft Excel for PC

dpprash,

I guess you mean the number of weekdays (or working days) excluding Saturdays and Sundays. So start a spreadshhet and put the start date (01/01/2009) in A2 and the end date (31/12/2009?) in B2.

Then paste the formula below into C2:

=B2-A2-2*INT((B2-A2+WEEKDAY(A2,3))/7)-MAX(0,WEEKDAY(B2,3)-4

better-swiss

I guess you mean the number of weekdays (or working days) excluding Saturdays and Sundays. So start a spreadshhet and put the start date (01/01/2009) in A2 and the end date (31/12/2009?) in B2.

Then paste the formula below into C2:

=B2-A2-2*INT((B2-A2+WEEKDAY(A2,3))/7)-MAX(0,WEEKDAY(B2,3)-4

better-swiss

Dec 18, 2008 | Microsoft Excel for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Computers & Internet

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Computers & Internet

hm I dont think that is possible with a formula. I think you need to use Macro.

Jul 18, 2008 | Microsoft Computers & Internet

88 people viewed this question

Usually answered in minutes!

×