Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

FORMULAS I WANT TO PUT A FORMULA TO COLUMS A5, A6, A7, .......... WHICH TAKES FROM A1, B1, C1 AND PULL IT DOWN TO CONTINUE

Posted by on

  • HelenStylli Sep 12, 2008

    what i want is to put a formula verticaly but it will take from horizontal values.



  • HelenStylli Sep 15, 2008

    i have this value



    B1, B2, B3, B4



    I want the formula starting from A1 to take the values from B1. Then A2 from B2........................



×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 50 Answers

Put in B column number from 1 to 100, and then use following formula in A column:

=INDIRECT(ADDRESS(1,B5,3))

Posted on Sep 11, 2008

  • Pav Z Sep 14, 2008

    Sorry for being not that detailed.

    Let's say you will have in B column numbers from 1 to 100. Then you can put to the A column following formula which will take values from horizontal cells.

    A5 formula will be =INDIRECT(ADDRESS(1,B5,3))
    A6 formula will be =INDIRECT(ADDRESS(1,B6,3))
    A7 formula will be =INDIRECT(ADDRESS(1,B7,3))

    The result will be that formula will be vertically but will take values from horizontally cells.



×

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:

1 Answer

How to do excel defined name formulas in microsoft excel 2007


Excel formulas really haven't changed at all, so any information you find on newer version of Excel will most likely apply to 2007.
However, to answer your question, let's look at the following scenario:
If A1 and B1 both have numbers and you want the cell C1 to be the result of adding A1 and B1, select the cell C1 and type "=SUM(A1:B1)" (without the quotation marks)
You can also do this by just typing "=SUM(" in C1 and then click and hold your mouse button on A1 and select B1 as well. Then close the parenthesis and press Enter. Done!

Hope this helps.

May 17, 2014 | Computers & Internet

1 Answer

IS THERE A PERCENTAGE FORMULA TO USE IN EXCEL


There isn't a function for this, but the formula should be something like this:
A1: Number to increase / decrease
B1: % change
C1: 'INC' or 'DEC'
D1: =IF(C1='INC', A1+(A1*B1), A1-(A1-B1))

Nov 17, 2011 | Microsoft Excel for PC

1 Answer

I need a formula length of service in DD/MM/YY on MS Excell


Format cells A1 and B1 to dates.

A1 is the first date
B1 is the 2nd date
C1 enter the formula below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

rootmailsd.jpg

Jun 23, 2011 | Microsoft Excel for PC

1 Answer

What is a plus formula.


=A1+B1

If you enter the formula below in cell C1, it will show the result of adding the values in A1 and B1

Feb 16, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

Sum function


Write down the number in cells for Example:

A1 (59)   Without Brackets
A2 (50)
A3 (80)  
A5  ?    ANY Number
A6  ?    ANY Number
A7  ?    ANY Number

A8 =SUM(A1:A7)     you will get total sum of above numbers on                                   this A8 Cell which is auto sum whenever you                                 change the value on above cell.

Feb 22, 2009 | Microsoft Computers & Internet

2 Answers

Excel farmulas


Add another colum, say D with result of B*C

Do a list of the different cat, and use sumif
For cat 0101 (in cell F1)
formula to put in G1
=sumif($A$1:$A$7000;F1;$D$1:$D$7000) where F1 contain 0101

expand the formula for other cat. (G2, G3, etc)

You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)

Feb 16, 2009 | Microsoft Excel for PC

1 Answer

I want to add two value of two field and display another field in form of ms access 2003


set field number 3 = to sum of first 2

example
A1 = 5
B1 = 6
C1 = A1+B1 which will make C1 show 11
type in C1 = then move cursor (arrow key) over to A1 then type + then move cursor to B1 then hit enter - formula showing in C1 on top should show
=A1+B1 and valud in cell should show 11

Jan 23, 2009 | Computers & Internet

2 Answers

Wanted to learn "ALL" formulas of MS Office Excel - please guide


Ist I want to know what type of formulas u use in works

Jan 13, 2009 | Computers & Internet

1 Answer

Microsoft excel


this is done through formulas. You write them in relationship to one another. Say you put a value into B1 then you write a formula for c2 like =SUM(A1/2)which means the sum of A1 divided by 2. or you can say make a formula that is like this =SUM(A1/C1) which means the value of A1 divided by the value of C1.

Jan 10, 2009 | Computers & Internet

1 Answer

Excel formula.....


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.

Jul 14, 2008 | Computers & Internet

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

Related Topics:

59 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

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

Answer questions

Manuals & User Guides

Loading...