Subtraction of 2 numbers/cells
Could anyone please help me with this situation (in Excel 2003):
I have 2 cells
A1 = 0 and B1 = 10
In cell C1 i put this formula C1=A1-B1 . Now the answer will be C1=
-10 but my question is:
Is there a formula to calculate in C1 the result if the answer is positive
and if the answer is negative to put 0?
Thank you in advance.
Try one of two:
> Could anyone please help me with this situation (in Excel 2003):
> I have 2 cells
> A1 = 0 and B...Change the formatting of row by select a single cell & Editing should be working
I require such a sheet code which can help me in Changing the
formatting of row (like A1:A25) of selected cell (A4 is Selected) and
allow me to use editing (Cut, Copy, Paste, Undo etc).
Currently I'm Using following code but this does not allow me to use
editing (Cut, Copy, Paste, Undo etc) and I can not decide the range for
working this sheet code.
Any kind help is appreciated.
Private Sub Search_Click()
Sheets("Quick Search").Visible = True
ActiveWindow.SelectedSheets.Visible = False
Private Sub Worksheet_...How to pick every third cell?
I have a spreadsheet with a column in which I keep dates. The date
appers in every third cell of this column and the other two cells are
blank. I have the another sheet in this workbook in which I want those
dates to appear in the column in consecutive order. I'm using cell
reference comand right now but have to do it manually every time I have
a new entries. So in the other sheet there is a column with cells
having references to every third cell in the first sheet. I trided to
high-lite the multiple bunches of cells and drag-copy it down - but
it's not working.
Tha...How do I get a query to add an incrementally increasing number?
I have a query that selects a subset of records. I need to add a "run
number" to that subset, starting with 100. That is, the first record is 100,
the second 101, etc. I know there has to be a way to do this, but I can't
figure it out
You might see if you can get this code to work for you:
I have not tried it out...
Microsoft Access MVP
> I have a query that selects a subset of records....Apointment time Changes
I have a group of users that when they send apointments or receive
apointments they time changes by an hour.. for example they send me a 3:00PM
apointment ill get it for a 4:pm apointment.. they are on the same network as
i am.. same exchange server... no one else has this problem.. has anyone come
across this problem?.. any help would be great!
The settings to adjust for daylight savings time are in Windows as well in
Outlook Calendar options. Both need to be checked.
"Chris" <Chris@discussions.m...Fyi..Support request regarding Windows Live Essential Wave 4 beta
This is a multi-part message in MIME format.
From the Windows Live Solution Center
To differentiate Windows Live Essentials Installer BETA related issues =
from the current version, please add the word =93BETA=94 in the =
=93Detailed Descriptions=94 to get your questions answered faster when =
creating a Post. This will help ou...Summing Time #2
I wish to calculate the time the machine has actually run.
D1 = 22:00 (Start Time) F1= Time Run
E1 = 00:15 (Finish Time)
D2 = 00:15 (Start) F2= Time Run
E2 = 02:30 (Finish)
D9 = 22:20 (Breakdown)
E9 = 22:30 (Restart)
D10 = 23:15 (Breakdown)
E10 = 23:30 (Restart)
D11 = 00:30 (Breakdown)
E11 = 02:00 (Restart)
Is there a formula that can scan a range (D9:E11) and
give me tha answer in F1 of the time run between the
Start & Finish times
any help would be appreciated
Array-entered (press ctr...Some Error that I can't figure out.
Ok I am typing in a bunch of UPC numbers for my data sheet, It will be a
couple hundred numbers. The UPC numbers are as follows
For some odd reason all the numbers without a zero are wrong. All of these
numbers need 1 number 0 in front of them. As for the other numbers I get a
little green arrow in the upper left corner of the cell. It tells me
Something about "Number stored as text" (This is the one...ask for overtime with time restriction
Hi I would like to know how I could set up an overtime list to where the cell
would turn red if you don't ask by a certain time. Example for saturday
overtime you must be asked by end of shift thursday so if you are asked on
friday it would go red and the same for sunday where you have to be asked by
friday. Thanks Karl Lungmus
I need to design a VBA macro that would find "paid" in Column A and would
select in value in column H.
Column A Column H
I need to select the $100.00
why not use application.vlookup?
> I need to design a VBA macro that would find "paid" in Column A and
> would select in value in column H.
> Column A Column H
> Paid $100.00
> I need to select the $100.00
Technically, I'm going ...Sheet Name Refering to Cell Value
I want to name a sheet to the cell value in A2. Cell A2 has an Alt-enter in
the cell. I want the sheet name to be the cell value of the first line only.
Can anybody help. TIA
Dim myStr As String
Dim vbLFPos As Long
myStr = .Range("a2").Value
vbLFPos = InStr(1, myStr, vblf)
If vbLFPos > 0 Then
myStr = Left(myStr, vbLFPos - 1)
On Error Resume Next
.Name = myStr
If Err.Number <> 0 Then
MsgBox "couldn...Converting Quatro Pro 5.0 file to Excell
Can this be done. If so, how. I would really like to
preserve and use my quatro pro files in excell. Thanks.
try the excel newsgroup...
>Can this be done. If so, how. I would really like to
>preserve and use my quatro pro files in excell. Thanks.
...how to add only positive number
i have a column which has positive as well as negative number but
would like to add only positive number, how do i,
please let me kno
Message posted from http://www.ExcelForum.com
> i have a column which has positive as well as negative number but i
> would like to add only positive number, how do i,
> please let me know
> Message posted from http://www.ExcelForum.com/
...Determine if a linked cell contains data
Using vba I'd like to change the formatting/colours on a particular cell
if the cell contains text.
So for example:
If Application.WorksheetFunction.IsText(Cells(i, ColNum)) Then
Cells(i, ColNum).Font.Bold = True
Cells(i, ColNum).Interior.ColorIndex = 40
This works fine for cells which do contain text but not for cells which
contain 'linked text'. I have some cells which are linked from a 2nd
sheet and in the 2nd sheet they contain text.
The code above does not work because there the cell contains ='Sheet2'!B93
How can I get ...Daylight Savings Time
Since the daylight saving time change. We are having
trouble with users calender appointments being 1 hour off.
We are using Exchange 5.5/Outlook 2000. In Outlook we had
them check the box indicating adjustment for daylight
saving time. After 2 days the time changed back an hour
again. This seems to be only happening with our XP users
only. Any ideas what is causing this.
Thanks in advance.
My guess is the time zone is wrong on their computer. Make sure the checkbox
for "automatically adjust the clock" is set.
I usually have users that like to manually change their clocks. ;...Address of Selection Prior to Clicking on a Cell
If I have cell b5 selected, and I click on cell e5, is there a way for
VBA to identify that it came from cell b5 before the click?
Code such as this can be set to be triggered when you click on a cell,
but can it tell you what cell it came from?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B5")) Is Nothing Then _
Range("B5").Value = 10
Try the below..
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static pRange As Range
If Not pRange Is Nothing Then MsgBo...can't sum figures in a report ...help please
I have a text box that uses an if statement to determine whether someone is
absent in my class or not. I name the text box inattendance.
I have a text box called points that assigns points to absent students
depending on which class they are currently enrolled in.
I want to sum the total points for each student. I do a simple
=sum([points]) and when I run the report I get a box that just says points
indicating that it doesn't have a definition for points. I used the name
property of the text box and called it points.
any suggestions on alernate methods or on what I am do...Run-time error 3077
In Access 2003, I am using VBA to find a string in a table. Every time I try
to execute following line:
anRST.FindFirst "John Smith"
I get "Run-time error '3077':" which says:
Syntax error (missing operator) in expression.
Same is true for FindNext, FindLast and FindPrevious.
anRST was defined using following code:
Set anRST = CurrentDb.OpenRecordset("Test", dbOpenDynaset)
Where "Test" is the name of the table.
Any ideas what I am missing?
Syed Zeeshan Haider
-----------------------------------------...Want Table cells in Word to format like in Excel
Operating System: Older version
(Leopard 9.1) <br>
I am trying to do up an invoice in Word and am using tables within it. I want to be able to utilise the Cells for various formats/categories, such as, time, numbers with varying decimal places and accounting ($0.00), like in Excel. Is there a way to do this as I am currently stumped? <br>
I don't really want to use Excel for invoicing as most of our invoices are emailed and I don't want the whole 'worksheet' viewable. Unless of course there is a way to make an Excel Spreadsheet to ONLY be one pag...can a column for 2 different words and display a number based on how many are found
This should be a very easy thing to do, but I can�t figure it out.
Please Help. Thanks!
I am trying to scan a column for 2 different words and display a numbe
based on how many are found.
If the words �Completed� and �N/A� are found within a column as liste
below. I want to create a formula that will display the number 5
because those words are found 5 times within that column.
Message posted from http://www.ExcelForum.com
=COUNTIF(A:A,"Completed")+COUNTIF(A:A,"N/A") for column A
...Run-time error '424'
Can anyone advise why I am getting a run-time error with this line (and what
I need to do to get it working?):
Me.Parent!Form.Bookmark = rst.Bookmark 'reposition the form
Here is the code I am trying to run:
Dim rs As DAO.Recordset
If Me.Parent.Dirty Then
Me.Parent.Dirty = False
'Search in the clone set.
Set rs = Me.RecordsetClone
rs.FindFirst "[RecID] = '" & Me.RecID & "'"
If Not rs.NoMatch Then
Me.P...Colour cell to return date
Hi all, this is what i wish to have happen; i have created a list of
activities B5:B25 say, next to them i have two column Start & Finish D & E,
next to them i have columns G to J, where G1:J1 has date fields in cells 8th
Jan 10, 15th Jan 10, to 29th Jan 10 week between them. The question is how
can i retrurn a date in cell D5 if i populate G5 (or fill with a colour)?
see Chip explanation
Color Change And Calculation
Excel normally calculates the formula in a cell when a cell upon which that
formula depends changes. For example, the formula =SUM(A1:A10) is
reca...convert Publisher version 2 files to Publisher 2003?
Does Microsoft have a converter for converting Publisher version 2 files to
Publisher 2003 or even to Publisher 2000?
Publisher 2003 should open your 2.0 files. Are you getting an error?
Mary Sauer MSFT MVP
"JAB" <JAB@discussions.microsoft.com> wrote in message
> Does Microsoft have a converter for converting Publisher version 2 files to
> Publisher 2003 or even to Publisher 2000?
Thanks for your response Mary. Yes I get ...Displaying large numbers in a cell
In a worksheet that one of my co-workers uses, she needs
to input numbers that are up to 16 characters long.
However, Excel for some reason is changing the last number
entered to a 0. For example, if she entered
4223980067104216, Excel would change it to
4223980067104210. If she entered 4223980067104212, Exel
will change it to 4223980067104210. I have tried changing
the column widths, cell formatting, check the options
under Tools, but I am not able to find anything to keep
this from occuring.
I have noticed that Excel does not make this change if
only 15 numbers are entered into a ...Converting from Quicken Deluxe 2004 to MS Money 2004 Deluxe
I downloaded and installed MS Money trial version and after trying to bring
across my Quicken QDF file, Money has the accounts but no entries in the
check registers. I tried both the File/ Import and the File/ Convert
function. I do not use passwords. How do I get the rest of my Quicken data
across? I am using Win 2000 pro.
Asked and answered several times a week. Mx can't import Qx and is not
documented as being able to, Mx can only import Qx-1 or less.
Mx and Qx come out at the same time. Money designers are not clairvoyant
about what the Quicken designers are doing.