Need help with formula
Wed, 17 Sep 2008 11:15:01 -0700
I use this current formula to keep track of cars sold in a month. I want to
keep track of the different models sold at our store in a month and have paid
cash. I keep a log in Worksheet1 and I want to have the results show in
worksheet2. Is there a way of streamlining the date portion to equal the
heading ...
|
Formula/calculation help for medical charting
Wed, 17 Sep 2008 10:17:01 -0700
Hi,
I am trying to develop an anesthesia record chart for the vet clinic I work
at. I have A8 through A15 labeled for time, temperature, heart rate, etc. The
other columns (B8-B15, C8-C15, etc) I have set aside for later entries in the
above categories as we take values every 5 min. or so.
What I would ...
|
Unprotect sheet/workbook
Wed, 17 Sep 2008 04:18:01 -0700
I protected the worksheets and the workbook. Now I need to unprotect them for
some changes, but on the review tab, unprotect sheet and unprotect workbook
is grayed out. I did not use any password. How can I unprotect this
workbook/worksheets.
Thanks,
Steve
...
|
What is the object of embedding, what is it used for?
Wed, 17 Sep 2008 02:43:00 -0700
I use excel often, but am only self taught, a work coluige embedded a excel
file by accedent but we think thne use could for us usable, what is the
pourpus of embedding and what is its use? ...
|
How do I change the color on scatter markers?
Tue, 16 Sep 2008 13:58:06 -0700
After I select Insert-scatter. I select "Scatter with only Markers" ( I pick
the upper left of the five choices). I can't change the blue markers to
black. Thanks for any help you can give.
Ralph ...
|
Formula Calculation
Tue, 16 Sep 2008 15:18:39 -0400
I have a real problem finding the right formula to calculate fees based on a sliding scale of units sold.
Here is the rule.
Units sold in a month between 1 and 19 pay a fee of $495.
All units sold in that month from 20 and over pay a fee of $385.
That is pretty simple, but here's the difficulty. During a s ...
|
How to Change Numbers to Text. ie $1.00 = one dollar
Tue, 16 Sep 2008 11:21:01 -0700
I am trying to convert Dollar amounts into written text in an excel
spreadsheet. How do I create a formula that will convert my Numbers to word
text.
i.e. $1.00 convert to One Dollar zero cents. $100.00= Convert to One
Hundred Dollars and zero cents.
--
ABA ...
|
|
|
Chart Help Please
Tue, 16 Sep 2008 12:46:18 -0500
Excel 2002
I have a simple chart: two columns (A and B) and 29 rows.
Column A is years, from 1980 to 2008.
Column B is some value between 0 and 9.
Example:
1980 0
1981 1
...
2008 4
I created a chart.
It plots the points fine, they are where they should be.
The Y axis is fine, numbers from 0-9, lab ...
|
calculate and show a 40% increase from one cell to another
Tue, 16 Sep 2008 07:53:06 -0700
--
Rog ...
|
Restoring number format
Tue, 16 Sep 2008 06:57:01 -0700
How do I restore the number format for excel? For example:
when I type in 45; cell automating displays .45. I have already tried going
to format>cell>general etc; but each time I open another workbook same thing
happens 45 becomes .45 ...
|
