Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Question is about Microsoft EXCEL FORMULA 1) Column A has 1,2,3,4 ?.. up to 31 starting from A1numbers 2) Column B1 has weekday code. Starting number may be any number between 1 to7. Suppose B1 is 5, B2 is 6, B3 is 7, B4 is 1, B5 is 2 and on. 3) In Column C it should copy column A1, A2?up to A31, starting from matching number of column A & B (First no of column B1 is 5 and fifth no of row column A is 5. In this case starting of C5 will be value of A1, ( C1 to C4 will be blank) C6 will be value of A2, C7 will be value of A3 and so on. What formula to be written in cells of column C ? In column A dates are written, column B weekday codes 1 to 7 are written

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Expert
  • 66 Answers

Try this:

=LOOKUP(B4,A$1:A$31,A$1:A$31)

Posted on Sep 06, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a...


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

Sep 26, 2010 | Microsoft Excel for PC

1 Answer

I use =TODAY()+1 formula for now because i work on document to be fax for the day after. every saturdays i have to fax my documents for the monday that means 2 days after,witch formula can i use to resolve...


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.

Apr 05, 2009 | Microsoft Excel for PC

1 Answer

Excel formula related to a date range


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.

Mar 20, 2009 | Oracle Database Enterprise Named User Plus

1 Answer

How to add % (Percentage column ) in the excel


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%).

Jan 03, 2009 | Microsoft Computers & Internet

1 Answer

Creating vacation accrual spreadsheet


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.

Dec 27, 2008 | Microsoft Office Standard for PC

1 Answer

DATE DIFERANCE BETWEEN SELECTED COLOUMN


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.

Dec 27, 2008 | Microsoft Excel for PC

2 Answers

Formula for Calculating the turn around time in excel


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

Dec 18, 2008 | Microsoft Excel for PC

2 Answers

Excel will not displaying the results of a trend array formula


Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

1 Answer

BASIC EXCEL FORMULA


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

Sep 29, 2008 | Microsoft Computers & Internet

1 Answer

Computer


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.

Aug 08, 2008 | Microsoft Computers & Internet

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

87 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18389 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...