Microsoft Excel for PC Logo

Question about Microsoft Excel for PC

3 Answers

I need an Excel formula help

I need help with an Excel formula. Col. A cell A1= A001 this number will be used as a reference number, A2=A002, A3=A003 - A12=A012 are filled. When A13=A012 is filled, A1 is moved to B12 but still remains A001. Data from A2 is moved up to A1, but will remain A002 and the same upward shift with all cell data in Col A, when A13 to A24 is filled, A1 is then moved over to B12, B12 is moved up to B11. It will take 12 new cells to be filled in Col A each time to move A1 over to B12. This same cycle will take place with Col B. It will take 12 cell shifts from Col A to move one up a cell in Col B. Now here comes the fun part, when A001 reaches B1 and A013 is moved over to B12, this will not only move A001 over to C12, this will also move A001 to a new book sheet one and will enter at Col A12. This will cycle up to Book 12. At book 12 the cycle will end for A001 when A001 goes from A12 up to A1 and is then pushed out.

Are you up for this challenge.

Posted by Bob Mims on

Ad

3 Answers

Anonymous

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Spread the Word:

    An expert who has shared 5 answers on their Facebook wall.

    New Friend:

    An expert that has 1 follower.

  • Contributor
  • 29 Answers

Http://atips4pc.blogspot.com/2012/02/all-in-one-excel-functions-and-excel.html

Posted on Sep 23, 2012

Ad

Anonymous

CREATE TABLE `callerfeedback` (
`Id` bigint(15) unsigned NOT NULL auto_increment,
`Contract` varchar(255) default NULL,
`ClassName` varchar(70) default NULL,
`DosDate` date default NULL,
`DosTime` time default NULL,
`FeedDate` date default NULL,
`FeedTime` time default NULL,
`Prefix` char(2) default NULL,
`Caller` varchar(50) default NULL,
`Mobile` varchar(30) default NULL,
`Email` varchar(50) default NULL,
`SendType` varchar(50) default NULL,
`UID` bigint(10) unsigned default NULL,
`ParentUID` bigint(10) unsigned default NULL,
`SmsDelay` char(1) default 'N',
`Server` char(1) default NULL,
`MailUID` varchar(25) default NULL,
`CityName` varchar(50) default NULL,
`EmailCreateDate` date default NULL,
`EmailCreateTime` time default NULL,
`EmailSentDate` date default NULL,
`EmailSentTime` time default NULL,
`EmailSubject` tinytext,
`EmailText` longtext,
`EmailReady` char(1) default 'N',
`EmailSent` char(1) default 'N',
`EmailTryDone` smallint(6) unsigned default '0',
`SmsCreateDate` date default NULL,
`SmsCreateTime` time default NULL,
`SmsSentDate` date default NULL,
`SmsSentTime` time default NULL,
`SmsText` text,
`SmsReady` char(1) default 'N',
`SmsSent` char(1) default 'N',
`SmsTryDone` smallint(6) unsigned default '0',
`Operator` varchar(30) default NULL,
`InstanceId` smallint(6) unsigned default NULL,
`SmsSendError` longtext,
PRIMARY KEY (`Id`),
KEY `IdIndex` (`Id`),
KEY `CityNameIndex` (`CityName`),
KEY `EmailReadyIndex` (`EmailReady`),
KEY `EmailSentIndex` (`EmailSent`),
KEY `EmailIndex` (`Email`),
KEY `MobileIndex` (`Mobile`),
KEY `SmsReadyIndex` (`SmsReady`),
KEY `SmsSentIndex` (`SmsSent`),
KEY `InstanceIdIndex` (`InstanceId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 1540096 kB; InnoDB free: 1572864 kB';

Posted on Mar 01, 2008

Ad

Anonymous

Vlookup Fomula

Posted on Mar 01, 2008

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

How do I create an Excel formula to subtract within a column, row by row?

put in result row
=A1-A2

or = A1-A2-A3

A being the column
the numbers 1 2 3 are the rows
or go to result cell type =
then click on cell then press -
then click on cell to minus then press -
the click on next cell to minus
1helpful
2answers

What are the formulas in grading the grades uisng microsoft excel

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.

  1. All formulas begin with an equals sign (=).
  2. 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.
  3. 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.
  4. 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.
  5. 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.
2helpful
2answers

I want to write an Excel IF statement using only mathematical operators (in another application). The Excel formulation is: ...

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

11_16_2012_10_24_08_am.png
1helpful
3answers

Ms-office

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:
  1. =A1-A2
  2. =SUM(A1,-A2)
The above formulas refer to cell reference A2 subtracted from A1. As usual, you can use number values instead of cell references.

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.
0helpful
1answer

Excel Formula

With data in A1 to C1: A2 =IF(A1>0,1,0) B2 =IF(B1>0,1,0) C2 =IF(C1>0,1,0) A3 =SUM(A2:C2)
1helpful
2answers

School Truancy Report Formula

For the same exemple you can try this:
=COUNTIF(A1:A4,"=George Washington School")
7helpful
4answers

Using excel to solve problem by trial and error method

In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh
0helpful
2answers

Excel formulas

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
0helpful
2answers

Formula for calculating the days beween months

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)
0helpful
2answers

Formular to show number and cell references

The formula for A1 is: =SUM(B4,B5)
A2 is: =SUM(C4,C5)
A3 is: =SUM(A1:A2)


To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.
Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

377 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

David Shaub

Level 3 Expert

2994 Answers

Mehandi Husain ...

Level 3 Expert

1654 Answers

Brad Brown

Level 3 Expert

19163 Answers

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

Answer questions

Manuals & User Guides

Loading...