Return Cell formula, not result
I want to return a cells formula string, not the result.
1 =B1 20
If I reference cell A1, I want the following result
PS. What is the search syntax to search ALL words, not
just any word. I tried searching the newsgroups but
could not narrow the search.
precede it with a single apostrophe
"Robert Randolph" <NOSPAAMMrob@KingdomSoftware.com> wrote in message
> I want to return a cells formula string, not the re...Formula for selecting a varying cell reference
I'm trying to tie 2 worksheets together. The first is a data entry sheet,
set up by month. The second is a sheet that I want to pick up monthly data
-- i.e., the most recent month of information entered on the data entry
sheet. Is there a formula I can write in the monthly sheet that will look at
the data entry sheet and go to the last monthly column that has data and
retrieve that? I guess I'm thinking like a flowcharting yes/no process
starting in December -- i.e.,:
Is December blank? Yes -- go to November; No -- use this data -- etc.,
...Connector Continued ...... [WP]
Thank you for your response.
Rich, I have changed the Scope Option to Organization as we only have 1
Routing Group and the IP address is in Sq. brackets as you mentioned.
So you are telling me fo rinbound mail I have to create another SMTP
connector but I am under the imprssion that the other organization has to
create a connector at their end to send us mail????? Why do I need to create
a rceiving connectro ... if yes, then please advise how do I create it to
receive from this other company?
you might want to look at these:
h...Need Help with a formula
I am working in a form. I have a field called Visiting Date and a
field called DOB and a field called Classroom. I am trying to come
with a formula in the Visiting date that will show if a Child's
Classroom = Bumble Bears, the visiting date needs to tell me the date
on his 15 months, when the Child's Classroom = Doodlebugs, the
visiting date needs to tell me the date on his 33 months.
I am looking for a formula to put into a bound text.
Can anyone help me. I have such a hard time with IF statements. Your
email@example.com wrote:...Screen updating and formulas
With Excel and VBA, as soon as you add a formula to a cell this updates the
screen. Does anyone know a way around this?
.Screenupdating = False
In the example above the screen updates after adding in the formula to cell
Any ideas from anyone would be appreciated.
"John" <firstname.lastname@example.org> wrote...
>With Excel and VBA, as soon as you add a formula to a cell this updates the
>screen. Does anyone know a way ar...when displaying formulas, how to start a new line in the same cel.
In the displaying formulas mode, if the formula is too long, how to start a
new line in the same cell so that the formulas can be printed in one page.
(Alt + enter won't work in formula mode)
AFAIK the only thing you could do is copy the formula as 'Text' (e.g.
put an apostrophe in front of the formula) and then use aLT+ENTER
"EL" <EL@discussions.microsoft.com> schrieb im Newsbeitrag
> In the displaying formulas mode, if the formula is too long, how to
sta...Trying to write a formula that changes which worksheet to used
I am trying to write a formula that uses a different worksheet in the current
workbook depending on the value from a lookup result and/or the direct entry
of a worksheet name in one cell.
For instance, if my lookup result is November, I want to pull information
from cells on the November worksheet, if December, information from the
December worksheet, etc.
This way, all I have to do is change the lookup value and/or the entry to
get different results based on the appropriate worksheet. This is useful in
repetitive activities using the same layout but different numbers.
Any help would...SQL: Summing By Date Continuously?
SecID PayDate PayAmount
003 01/01/2007 123.97
004 01/01/2007 4250.63
003 01/02/2007 123.43
003 01/03 2007 120.45
003 01/04/2007 119.20
003 01/05/2007 130.44
...and so on for each and every day
What I want to do is present, for a given SecID, the total daily
accruals from tblPaymentSchedule.PayDate to the next (actually,
the day after one PayDate to the next...if statement formula
I want to create a cell that takes a total, and multplies it by 15%, however,
if the 15% is less than twenty, I want the amount to be 20.
I.E.-- subtotal is $95.00, so 15% would be $14.25. However I want the cell
I.E.-- sutotal is $300.00, so 15% would be $45.00. I want the cell to show
If your total is in cell A1 then in B1 type =IF(A1*0.15<20,20,A1*0.15)
> I want to create a cell that takes a total, and multplies it by 15%, however,
> if the 15% is less than twenty, I want the amount to be 20....Help on formula
I have the following columns:
A. Cost B. Plan C. Additional D.
$100.00 OTN $35
$150.00 OTN4 $25
How can i get the TOTAL field to calculate Column A and C only when there is
a value entered in Column A? In case you are wondering, the Additional
Column (c) has assigned values, however I don't want a...copying formula with worksheet name-need new formula to have another worksheet name
I want to be able copy a formula from b5 to b6 but have the worksheet
name change, i.e.:
I have 13 sheets in my workbook; the first sheet is called Summary
which is where my formula presides. 2nd sheet,3rd sheet, etc. are
called Sal Hrs_Jan10, Sal Hrs_Feb10, etc.
My formula in b5 is =+'Sal Hrs_Jan10'!$C$15.
I want b6 to say =+'Sal Hrs_Feb10'!$C$15
I want b7 to say =+'Sal Hrs_Mar10'!$C$15
Column a, cell a5 has Jan-10 (this is a date 1/1/2010 formatted as
Can anyone help me???
Put this in B5:
=3DINDIRECT("'Sal Hrs_"...Formulas not showing
When I click Tools, Options, View, Formulas it doesn't
show the formulas. Can it be disabled some where else?
You don't say if the formulas are visible in the formula bar, or when in
Edit Mode. One possibility is that the cell(s) are set to "Hidden"
(Format - Cells, Protection), and the sheet is protected (Tools, Protection,
Regards from Virginia Beach,
"Richard" <email@example.com> wrote in message
> When ...Continuous Numbering
This is a multi-part message in MIME format.
How does one invoke continuous numbering when there has been a break and =
the numbering starts over again? Word has a drop down menu for this, =
but I can't figure out how to do so in Publisher.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Tr...Transposing Formulas
Can anyone help me to transpose this decibel formula, DECIBEL = V1/V
LOG20, If I know V1 and I know the decibel I need to work out V2 ...
Johno's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2857
View this thread: http://www.excelforum.com/showthread.php?threadid=48241
A little algebra:
V2 = V1/Decibel Log20
In article <Johno.firstname.lastname@example.org>,
Johno <Johno.email@example.com> wrote:
> Can anyone he...how do I write a formula for?
I want to add e2 thru e7 and e10 thru e14 together into a separate cell and
i just can't figure how to write the formula
Microsoft MVP - Excel
"Terry" <Terry@discussions.microsoft.com> wrote in message
>I want to add e2 thru e7 and e10 thru e14 together into a separate cell
> i just can't figure how to write the formula
Gosh Thaks Nick, I am no means a master and manage ...Formula #42
I have a spreadsheet that has dates intact from 2004
How could I change the dates to show the same date for
Day Date Name Task
Sat 11/3/2004 Joe Bloggs Sales
Sat 18/3/2004 Ben Dunne Testing
I would like the same sheet to show in column B which
holds date, to show the Sat date exactly 1 year later 2005
If all dates are numeric dates and they are all 2004 dates, put 366 in a
cell, copy it, select all dates <= Feb 29 2004 and do
edit>paste special and select add, reformat as dates because you will
probably get a serial number. Put...Joining text with a formula in cell #2
Thanks, I'll try and explain a bit better
If you want to show the result of a formula and text in the same cel
you can use something like this =SUM(A1:A4)&"*".
This will sum the A1:A4, show the result and put an asterix at the en
of the number.(eg 22*)
But the problem occurs when the sum has decimal points. If the forma
is set to 2 decimal points but the sum is greater than 2 decimal point
then it does not round it to 2. It shows as 22.444444444444444* when i
should be 22.44*
It is like the tip "Joining text with a linked date in Microsof
---...Can you insert formulas into tables in Publisher?
I'd like to insert a formula into a Publisher table like how it works for MS
Word -- for example "=SUM(ABOVE)". Is it possible?
> I'd like to insert a formula into a Publisher table like how it works for MS
> Word -- for example "=SUM(ABOVE)". Is it possible?
No. You can if you insert an Excel spreadsheet (instead of a table) as
an OLE object using Insert > Object.
Ed Bennett - MVP Microsoft Publisher
...Drag Down Formula Incorrect
I've got a long list of text data in column A, and am using the MID command
to extract one bit of data from each which is then inserted into four columns
When I drag down B9, I want the formula to change by 20 (from A27 to A47). I
have created 25 rows now, but the drag down still won't pick up the pattern
of 20 between cells.
Can anyone tell me how to achieve this?
How about this
"Disco3Stu" <Disc...Why is it continuously contacting server
I have had to uninstall and reinstall Office 2007. Ever since then, outlook
is almost continuously contacting the server. It does this so often that i
barely have time to delete messages or even read them.
I ran diagnostics and nothing was found.
It is running my limited download up to near 90% and I am getting notices
from my ISP on this.
How can I fix this?
"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
>I have had to uninstall and reinstall Office 2007.
Why? Uninstalling and re-install...Formulas in Worksheets
How to save formulas on worksheets when creating new year sheet?
CTRL + a to select all cells.
F5>Special>Constants(tick the ones you want/don't want to select)>OK
Formulas will remain ready for new data to be entered.
Gord Dibben Excel MVP
On Tue, 15 Nov 2005 14:19:02 -0800, "MusicMan"
>How to save formulas on worksheets when creating new year sheet?
...Continuous Form, Window Top Record Ordinal
On continuous view forms, there should be a form property that has the
recordset ordinal of the top-most record currently displayed in the form’s
window. For example, if a recordset contains 100 records and the
CurrentRecord is 5 and the user scrolls down until the CurrentRecord
disappears off the top of the screen, what is the recordset ordinal for the
record that is now at the top of the window? Left clicking on the scrollbar
slider will display “Record: x of y”, but there should be a property that
contains the value of x for code purposes. Perhaps call it
“WindowTopRecord...How do I average a formula without calculating zero values?
I want to average a column, except for the cells that have zero as a value.
How do I do this?
which is an array formula so commit with Ctrl-Shift-Enter.
"KMHarpe" <KMHarpe@discussions.microsoft.com> wrote in message
> I want to average a column, except for the cells that have zero as a
> How do I do this?
Our company has installation billing codes that are either primary or
secondary. Every job must have 1 primary code, and may have 0, 1, or many
I had originally set up the billing codes as a 'details' table, which
displays in a subform on my frmWorkOrders.
The control BillingCode uses a lookup which references a list of all billing
codes, and the list has a yes/no to indicate which codes are primary.
My question is this... Is it possible to have the subform only show primary
codes originally, then once a primary code is chosen, subsequent records in
the subfor...Format when viewing formulas
I'm trying to get two prints of the same document: one showing absolute
numbers and the other showing the formulas.
When I'm pressing ctrl+~ to show functions for my 2nd print, the format is
changing. The cells are getting too wide, so I end up getting only the left
half of the document in print preview. How do I change the document to show
functions with the format staying the same so I can print it??? Thanks.
Page Setup/Page/Fit to 1 page(s) wide.
In article <D2EAE056-FC1E-4F40-BA48-974B191C4B8D@microsoft.com>,