Question about Microsoft Office Standard for PC

Example wrksheet 1 (P1=2) need P1 in work sheet 2 to =3

You can access numbers from another worksheet by using the formula (=SheetName!P1)

That would access cell P1 on the worksheet called "SheetName"

Posted on Jan 12, 2009

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

You can use IF and ISBLANK. Put this formula on Sheet 1 D1:

=IF(ISBLANK(Sheet3!AM2),"x","")

You can replace "x" by any other value you need.

=IF(ISBLANK(Sheet3!AM2),"x","")

You can replace "x" by any other value you need.

Mar 04, 2010 | Microsoft Excel for PC

The VLOOKUP function is a handy one to know when you want Excel to
lookup a value in one place and insert it in another. For example,
let’s say you have a list of all of your customers on a sheet named
“Accounts” and an invoice on another sheet named “Invoice”. When you
type in their account number on the Invoice, you want Excel to fill in
the name of the customer and their address (and this information is
included for all customers on the Accounts sheet). A VLOOKUP will do
this for you.

Here's a tutorial that will help:

http://www.timeatlas.com/mos/5_Minute_Tips/General/Learning_VLOOKUP_in_Excel/

Here's a tutorial that will help:

http://www.timeatlas.com/mos/5_Minute_Tips/General/Learning_VLOOKUP_in_Excel/

Jun 12, 2009 | Microsoft Excel for PC

Place the numer to be update in one cel

In anither cel say cel=cel+1 because of the alpha "S" here you need to combine 2 things.

3 formulas in excel.

right string

add 1 to val(3charactersfromright)

combining s with converted new serialnumer

Personally I prefer Foxpro for these tasks.

For large amount of numbers this is no excel task.

Have no english excel here. Look up the easy function types.

You need no visual basic for this.

In anither cel say cel=cel+1 because of the alpha "S" here you need to combine 2 things.

3 formulas in excel.

right string

add 1 to val(3charactersfromright)

combining s with converted new serialnumer

Personally I prefer Foxpro for these tasks.

For large amount of numbers this is no excel task.

Have no english excel here. Look up the easy function types.

You need no visual basic for this.

Apr 10, 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

You can use some add in for Excell, can be found much of them on internet. Or follow this instruction: http://www.cpearson.com/excel/Duplicates.aspx for any brainstorming :)

Mar 11, 2009 | Microsoft Business & Productivity Software

Hello dear

I am also getting same issue on excel so I was getting many problem to work in MS Excel 2007. So I have solved it this issue and I am happy to share the solution with you all.

Solution:

Thanks

Muhammad Waseem Alvi

Software Configuration Management Engineer

Lahore - Pakistan

I am also getting same issue on excel so I was getting many problem to work in MS Excel 2007. So I have solved it this issue and I am happy to share the solution with you all.

Solution:

- Click on Excel Button which are displaying on left top corner.
- Click on Excel Options.
- Then click on Add-Ins option.
- You can find a Manage field in the bottom. Select Excel Add-Ins and click on Go button
- You will find a Add-Ins window. Please un-check all Add-Ins except Analysis toolpak and Analysis toolpak VBA.
- Click on OK button.
- Close excel file and open again excel file.

Thanks

Muhammad Waseem Alvi

Software Configuration Management Engineer

Lahore - Pakistan

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

Here is one way I just tried:

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)

That will add 3 years.

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)

That will add 3 years.

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy

Nov 21, 2008 | Microsoft Excel for PC

hello

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

Oct 09, 2008 | Microsoft Excel for PC

eg if i want to add to numbers

in sheet 1 i have the value 20 in cell B3

in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

in sheet 1 i have the value 20 in cell B3

in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

Mar 13, 2008 | Microsoft Excel for PC

Apr 25, 2014 | Microsoft Office Standard for PC

88 people viewed this question

Usually answered in minutes!

×