Question about Microsoft Windows XP Professional

Ad

Hi,

a 6ya Technician 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 repair professionals here in the US.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

Ad

I assume that the dates you want adjust are in date form and are in regular columns (or rows).

If so, then you can use a formula like this =DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))

where the original date is in cell A3.

You can then copy this formula to calculate all the new dates you need, and then copy the results back over the original dates as VALUES.

If so, then you can use a formula like this =DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))

where the original date is in cell A3.

You can then copy this formula to calculate all the new dates you need, and then copy the results back over the original dates as VALUES.

Oct 17, 2013 | 1996 Italdesign Formula

Here, We deal with Some Special Products in Polynomials.

Certain products of Polynomials occur more often

in Algebra. They are to be considered specially.

These are to be remembered as Formulas in Algebra.

Remembering these formulas in Algebra is as important

as remembering multiplication tables in Arithmetic.

We give a list of these Formulas and Apply

them to solve a Number of problems.

We give Links to other Formulas in Algebra.

Here is the list of Formulas in

Polynomials which are very useful in Algebra.

Formulas in Polynomials :

** Algebra Formula 1 in Polynomials: ** * Square of Sum of Two Terms: *

** (a + b)2 = a2 + 2ab + b2 **

** (a - b)2 = a2 - 2ab + b2 **

** (a + b)(a - b) = a2 - b2 **

** (a + b)(a2 - ab + b2) = a3 + b3 **

** (a - b)3 = a3 - 3a2b + 3ab2 - b3 = a3 - 3ab(a - b) - b3 **

(First term + Second term)2

= (First term)2 + 2(First term)(Second term) + (Second term)2

Jul 02, 2011 | Computers & Internet

Let say you have table like this

' A ' B

---'--------------'-----------

1 ' First ' 2

2 ' Second ' 1

3 ' Third ' 3

On Cell C1 or other cell you like, try to type this formula

=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))

That's all, just IF and math operand

' A ' B

---'--------------'-----------

1 ' First ' 2

2 ' Second ' 1

3 ' Third ' 3

On Cell C1 or other cell you like, try to type this formula

=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))

That's all, just IF and math operand

Apr 05, 2011 | Microsoft Excel for PC

Here is the syntax: =SUMIF(Sheet2!A1:A3,"> 1", Sheet2!B1:B3)

This says if the cells A1 through A3 in worksheet "Sheet2" are greater than 1 then return the values from worksheet "Sheet2" cells B1 through B3.

Change the worksheet name Sheet2 to your worksheet name and change the cell references to the ones you need.

This says if the cells A1 through A3 in worksheet "Sheet2" are greater than 1 then return the values from worksheet "Sheet2" cells B1 through B3.

Change the worksheet name Sheet2 to your worksheet name and change the cell references to the ones you need.

Apr 17, 2009 | Computers & Internet

Open excel and do the following...

A1:**Weekly Entry** B1: **Weekly loss** C1:**Total loss**

A2: Enter pound B2: Nothing Yet C2: Nothing Yet

A3: Enter pound B3:=if(a3="","",a2-a3) C3: =if(a3="",'',b3-b2)

Last thing you need to do is copy the cells A3,B3, and C3 and paste to the next row for every week.

A1:

A2: Enter pound B2: Nothing Yet C2: Nothing Yet

A3: Enter pound B3:=if(a3="","",a2-a3) C3: =if(a3="",'',b3-b2)

Last thing you need to do is copy the cells A3,B3, and C3 and paste to the next row for every week.

Feb 24, 2009 | The Learning Company Achieve! Math &...

=10000*(1+0.96)^12

=10000*(1+0.10)^18

=10000*(1+0.10)^24

=10000*(1+0.10)^18

=10000*(1+0.10)^24

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

You can do that using the formula CONCATENATE, solving your report.

in C2 you could write: =CONCATENATE(A2,B2)

in C3 you could write: =CONCATENATE(A3,B3)

in C4 you could write: =CONCATENATE(A4,B4)

in C5 you could write: =CONCATENATE(A5,B5)

in C2 you could write: =CONCATENATE(A2,B2)

in C3 you could write: =CONCATENATE(A3,B3)

in C4 you could write: =CONCATENATE(A4,B4)

in C5 you could write: =CONCATENATE(A5,B5)

Nov 24, 2008 | Microsoft Office 2003 Basic Edition...

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.

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

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

The problem doesn't say this explicitly, but it looks like you're using Excel. This answer depends on that assumption being correct.

Are you saying that some of your inputs are blank? And LOOKUP fails to map them to 0? Or are you saying that some of your values come back from LOOKUP as blanks? (They shouldn't; lookup should return either a value from the lookup table or an error.) Or is it the case that some input values get mapped to blank by your LOOKUP function?

Assuming that you're getting blanks back from LOOKUP where you wanted zeros -- for whatever reason -- here is something you can try.

It looks like the value you're looking up is in cell A3. Let's say your formula (the result of the LOOKUP) is in B3. In C3, you can put the formula =IF(ISBLANK(A3), 0, A3). This function tests if A3 is blank. If it is, it returns a 0. If it's not, you get A3 again. (But A3 has to really be blank -- spaces will count as non-blank.)

Then, you can copy data out of column C instead of column B, and it should have zeros in place of blanks.

Are you saying that some of your inputs are blank? And LOOKUP fails to map them to 0? Or are you saying that some of your values come back from LOOKUP as blanks? (They shouldn't; lookup should return either a value from the lookup table or an error.) Or is it the case that some input values get mapped to blank by your LOOKUP function?

Assuming that you're getting blanks back from LOOKUP where you wanted zeros -- for whatever reason -- here is something you can try.

It looks like the value you're looking up is in cell A3. Let's say your formula (the result of the LOOKUP) is in B3. In C3, you can put the formula =IF(ISBLANK(A3), 0, A3). This function tests if A3 is blank. If it is, it returns a 0. If it's not, you get A3 again. (But A3 has to really be blank -- spaces will count as non-blank.)

Then, you can copy data out of column C instead of column B, and it should have zeros in place of blanks.

Jan 05, 2008 | Computers & Internet

Mar 05, 2014 | Microsoft Windows XP Professional

Feb 19, 2014 | Microsoft Windows XP Professional

Feb 17, 2014 | Microsoft Windows XP Professional

58 people viewed this question

Usually answered in minutes!

In which spreadsheet?

×