I have been given the task of adding to an existing spreadsheet.
The problem I have is I think quite simple but I can't get my head around it.
1 | A | B | C
2 | 100 | 201 | =SUM(A2:A5)
3 | 235 | 203 |
4 | 1,232| 309 |
5 | 1,125| 201a |
At the moment the sheet has the above...
Well I think perhaps it's an if() problem.
I have 3 columns, A, B and C labeled “IN”, “OUT” and “BALANCE” in row 1.
So in row 2 I feed last months carry over balance into “2A” and set “2C = 2A”
Then row 3 onwards I set “3C = 2C + 3A – 3B”
(new balance = previous balance plus IN minus OUT)
But...
In Excel 2003 I am trying to do a simple alternate line color with "FORMULA IS" and "=MOD(ROW(),2)"
This throws a error and highlights the ",2"
I have tried typing the data in manually and also tried cut and paste from various help sites.
What am I doing wrong?
Ken
Every time I boot XP sp3 I get the "Found new hardware" wizard. Seems XP thinks I have a PCI device.
If I do what it asks it eventually says "can not install."
So I put a tick in "don't prompt....." and then it all starts again.
Found new hardware, found new hardware, found new hardware until I...
When I fire up VFP9, SP2 I go to [Tools] and [Class Browser] is greyed out.
I go to [Tools] [Options] and put in the path to BROWSER.APP.
I hit [Set As Default]
OK, all is well, until next time I load VFP when I have to do it all over again.
What am I missing?
How do I make the path to...
I'm sure this will turn out to “dumb question of 2010” but I just can't get AMEMBERS() to work for me.
I've searched high and low and found literally hundreds of sites and books that give the same sample.
goForm1 = CREATEOBJECT("Form") && Creates a Form
= AMEMBERS(gaPropArray, goForm1, 1) &&...
I have a dozen or so Command Buttons on a form which allow the user to input information easily.
Button "Command1" may have the caption "FROGS" and when clicked return "XF001" which is a code in a product datafile for frogs.
My question.. How can I allow these captions and what they return be...
I've read and re read several posts that have had the same or a similar problem but I can't find an answer.
Out of the blue, a few days ago, each time I double click a folder, in either Windows Explorer or Opus Explorer or even on the desk top, I get a window headed "Windows Installer" and a...
Regarding conditional formats .
Normally, in Excel, I manually create "striped" sheets to resemble fan fold paper by highlighting the whole spreadsheet and then going into conditional formatting and selecting "formula is" and "=MOD(ROW(),2)=1" and "light yellow", which produces sheets that are...
I can format an Excel sheet OK with statements like ....
oExcel.ActiveSheet.Columns[6].NumberFormat = "##,###.00;;"
And
oExcel.ActiveSheet.Columns[2].ColumnWidth = 8
And so on, but I can't for the life of me figure out how to programmatically split the sheet so that the column headings in row...
When exporting to EXCEL 5 there is a limit of 16,384 records.
I have well over 60,000 records.
Is there some way to get around this 16,384 limit?
Is there a way to concatenate sheets or some such work around?
I think Excel can IMPORT an unlimited number of records. Could an Excel macro be run...
How can I programmatically check that a .dll is present on a users machine?
I want to add speech to a VFP program but I will first need to check that xxxxx is registered and then do a if...else...endif.
Aussie Ken
"Far, Far Away"
CAMIGUIN ISLAND
This has been asked several times in the past but never answered so here it is again...
How do I position a WAIT message relevant to the VFP window as opposed to relevant to the Windows Desktop.
Aussie Ken
"Far, Far Away"
CAMIGUIN ISLAND
I’m beginning to think the following is not possible but perhaps someone can figure this out.
I have to work with an bean counter (accountant) who breaks months down into periods that run from the 1st of the month up to and including the first Sunday for period one, then from Monday to Sunday as...
I have a bit of code that adds figures from sales sheets for given periods.
These periods (week 1, week 2 week 3 etc) are....
Week 1: from the 1st of the month to the first Sunday.
Week 2: from the following Saturday to the following Sunday
and so on, NOTE that the first and last weeks may well...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.