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 on

3 Answers

  • 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.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 29 Answers

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

Posted on Sep 23, 2012

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

Vlookup Fomula

Posted on Mar 01, 2008

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 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

Dec 08, 2016 | Computers & Internet

10 Answers

In Excel adding positive and negative numbers


Yes,


  1. Select the column. (click on top of the column it will select)
  2. Right Click and select Format Cells.
  3. Select Currency in Category then press OK
b6298df.gif Now just type your Numbers i.e. 571 for $571 and -650 for -$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

2 Answers

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.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

2 Answers

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

Apr 05, 2011 | Microsoft Excel for PC

3 Answers

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.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

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)

Jun 04, 2009 | Microsoft Office Excel 2007

2 Answers

School Truancy Report Formula


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

Apr 03, 2009 | Microsoft Excel for PC

4 Answers

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

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

2 Answers

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)

Aug 25, 2008 | Microsoft Office Professional 2007:...

2 Answers

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.

Mar 07, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

346 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...