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...
Thanks guys and gals, solved it.
I used =IF(A3+B3<>0;C2+A3-B3;0)
In other words, if column A + B are zero then so is column C
Otherwise do the sum and put it in C.
Thanks all.
This might explain better what I'm trying to do.
1: A B C
------------------------------
2: IN | OUT | BALANCE
------------------------------
3: 1,000 | | 1,000 < C3=A3 (this is a carry over balance)
4: | 200 | 800 < C4=C3+A4-B4 (new...
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
<<< So one of BadBigBen's final suggestions fixed it.
Not so.
What I wanted was to solve the problem but after trying all the members suggestions I just gave up and deleted the sound card in the BIOS, which was always an option.
But thanks Ben and others, all good advice,
Sorted.
I gave up trying to repair the problem so after much searching in the BIOS to find VIA HDA (it's under AZALIA HDA)I disabled it and fitted a cheap PCI audio card and all is OK.
Thanks to all members.
Kenny in Angeles city,
Driver Max says I have all up to date drivers INCLUDING the Via Hi Def Audio one.
Ive only had the problem recently but I can't remember when exactly it started.
There is a Audio chip built into the mother board but it no longer appears on the hardware list in the BIOS.
How can I stop XP...
Sorry to take so long getting back but I have just moved from Camiguin island in Mindanao to Angeles city in Luzon and setting up house has been a number one priority.
Thanks for all the suggestions.
I have tried all the above to no avail.
Unknown Device Identifier finds a VIA Chip Technology Hi...
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...
SOLVED.....
Someone, no names no packdrill, had edited config.fp
I had entries like [_BROWSER = ""] and [RESOURCE = OFF].
It seems that this is the master setup file.
Thanks again for the input guys.
Thanks Mike, yes, I sort of guessed I could do something like that.
But how does VFP load these settings?
Where are these paths, like the path to BROWSER.APP kept?
Are they only in the registry?
If so, why is VFP reading some but not others?
How can VFP possibly discard these settings?
What...
For what its worth, I have just changed [Tools] [Options] [Regional][DatFormat] to British (was American) and that stuck even after restarting Windows XP.
Is that a clue?
Hi Mike,
Thanks for the input,
>Set As Default in the Tools / Options dialogue?
Done
>_BUILDER which points to your class browser
I have both _BUILDER and _BROWSER, both set to the correct path.
Still no joy
Maybe it's the rainy season here but I seem to be confused 10 or 20 times more than...
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.