If/then to print text.

I want to use a formula so that when a value over zero is put into one cell, 
a line of text prints in another cell.  I know it is an if then function, but 
I've forgotten the exact formula and the way to encode the text message in 
the formula.
0
Shadyhosta (15)
2/17/2005 7:53:04 PM
excel.newusers 15348 articles. 2 followers. Follow

2 Replies
738 Views

Similar Articles

[PageSpeed] 3

Shadyhosta wrote:
> I want to use a formula so that when a value over zero is put into one cell, 
> a line of text prints in another cell.  I know it is an if then function, but 
> I've forgotten the exact formula and the way to encode the text message in 
> the formula.
Try this:

=IF(A1>0,"print this text","print this other text")

gls858
0
gls858 (460)
2/17/2005 8:39:17 PM
The value is in A2
In the other cell enter

=IF(A2>0,"this is greater than zero or what ever","")

Regards
Bill K
"Shadyhosta" <Shadyhosta@discussions.microsoft.com> wrote in message 
news:0314210D-14C9-428C-8F56-9303AF1B871B@microsoft.com...
>I want to use a formula so that when a value over zero is put into one 
>cell,
> a line of text prints in another cell.  I know it is an if then function, 
> but
> I've forgotten the exact formula and the way to encode the text message in
> the formula. 


0
2/17/2005 8:44:21 PM
Reply:

Similar Artilces:

change page setup from printing 1 business card to 2 rows of 5
the program wont let me make this simple change. all i want to do is set up the page so that it prints the card in two rows of 5 but there is no way to change it. Oh but there is, give this a try. Here's I do it with Publisher 2000. File Page Setup Special Size Business Card from the drop down menu OK Create card. Assuming you are using standard business card stock of 2 wide and 5 high; File Print Page options button Print multiple copies per sheet Custom options button Margins = .5" Gap = 0" Side Margins =...

Outlook 2007 Autocorrect with formatted text
I need to know how to enable Outlook to replace autocorrect entries with formatted text. In Word 2007, its as simple as clicking the radio button to enable it. In Outlook however, not so much. Here is what I am trying to accomplish -- this worked two weeks ago before my hard drive died, however, I can't remember how to recreate it. I enter my initials and autocorrect formats a signature with contact information. The path, Tools, Options, Spelling, Spelling, Spelling and Autocorrect Options, Autocorrect Options --- however, the "Formatted text" radio button is ...

question about watermarks and text (non-wrap)
I am creating small labels, and have created a watermark, but can't figure out how to place text directly over the watermark. I have tried the front to back option, as well as some of the options for photo format, but each time I try to do this the text slides around the photo. If you can help, please email me at: cynthia@peconicbaywinery.com Thank you! Create the text box. Now make the text box transparent by using the Cntrl T keys. Drag the text box over the watermark, if not already there. That's it. -- Don Vancouver, USA "Cynthia" <Cynthia@discussions.microsoft....

how to add an outlook email to a text box in an access form?
Hi, I searched everywhere for a similar issue but in vain... I have a form used to enter computer issues. I would like to add to it a text box that will store emails. It could be a button that opens a link to the email. I hope this is clear. thanks. Ismail -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200803/1 ...

Extra Data when Printing email
On my work computer I can print email and everything works fine excep for one thing... at the top of the email is always posts some data (on line across the top) that has nothing to do with the email I a printing. The line consits of some data from a very old email and add the date subject, sender, and time. Then the rest of the email print normally on the rest of the page. Any ideas as to why outlook is addin this extra data ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ...

Pivot Table
Hi, I have a Pivot table with some numbers in it. Is there a way to replace the numbers with a text? For example: replace all numbers >1 with "yes" . Is this possible? If not whats the best way to achieve this? Regards, Vinstream Only by changing your data source. Eg. Sub Test() Dim rCell As Range For Each rCell In Range("DataSource").Columns _ (2).SpecialCells(xlCellTypeConstants, xlNumbers).Cells If rCell > 1 Then rCell = "yes" Next rCell End Sub "vinstream" <vinstream@gmail.com> wrote in mes...

Pretty print XML?
I am sure this has been asked enough to warrant an FAQ but I could not find it. Does anyone have some code and maybe an XSLT stylesheet that would allow me to transform an XML string to a "pretty" version (nodes indented on separate lines, etc.)? Thank you for your help. Kevin Kevin Burton wrote: > I am sure this has been asked enough to warrant an FAQ but I could not > find it. > > Does anyone have some code and maybe an XSLT stylesheet that would allow > me to transform an XML string to a "pretty" version (nodes indented on > separate lines, et...

printing background
I am using the 2000 version and the graphic (fill effect is gray) is not printing at all as a watermark. I have searched every Publisher Help and Troubleshooter issue for watermarks in the background, but nothing addresses this problem I am having. I did check to confirm that my printer has the latest drivers. I greatly appreciate any guidance with this dilemma. Andy Publisher doesn't use Watermarks the way Word will. In Publisher, View, Background (ctrl+m), put your lightly colored graphic here. I have found if you use WordArt and select a very light aqua it will print light...

Text box shadow in Publisher
When I create a text box shadow in Publisher 2002, I get a shadow line, but now shadow fill. The only option available to create a fill fills the whole text box, not just the shadow area. Any solutions? -- Clare Clare again... Correction: "I get a shadow line but NOT a shadow fill." ... -- Clare "Pastor Clare" wrote: > When I create a text box shadow in Publisher 2002, I get a shadow line, but > now shadow fill. The only option available to create a fill fills the whole > text box, not just the shadow area. Any solutions? > -- > Clare Right-click ...

journal printing interrupted
Hello, I have an issue where a SOP batch always results in the: " batch was interrrupted while receiving data from another module and is available in the Batch Recovery Window." error. It is available batch recovery with a status of "Journal Printing Interrupted". Upon further checking I found I am unable to print anything so it seems to be a print driver/setup issue. The system is remote so I don't have access to the printer. Is this possibly a service pack issue? ...any ideas? thx, Doug -- Doug Wilson Great Plains Consultant MCS Canada ...

saving to .csv and preserving numbers as text
I am trying to export from Excel to .csv and want to preserve data such as "1100.000" just as it is without loosing any digits. Any ideas? Bill, This should work! I realize you posted in .misc, but a macro is all I could come up with! Sub ExportCSV() Dim fs, f OutFile = Application.GetSaveAsFilename(FileFilter:="CSV (Comma delimited)(*.csv), *.csv") If OutFile = False Then Exit Sub ActiveSheet.UsedRange.Select Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile(OutFile, 2, -2) For Rcount = 1 To Selection.R...

Outlook not printing headers
Hi there, I am trying to print a hard copy of emails that i send. When i attempt tp print the email only the body of the email and my signature are printing. The headers (To:, From:, Subject: etc...) are not visible. I don't think this is an issue but just an option I am overlooking somewhere. I have thouroughly searched the options from tools and have had no success. Any Ideas? Thanks ...

Emails
I have a stack of emails concerning items of equipment. I have saved them in text format and I would like to track them for auditing. I need to get them into Access (I know how to call Word for Windows) and then I need to parse them, to dentify the fields "To", "From", "Date Sent" etc. My problem is that I can't get clear how I can go from a text file opened in Word to the process of parsing it and saving the strings in a table. If anyone knows of a website with some examples it would be a nice Christmas gift. Leonard Priestley I don&...

Greek text on media player 12
I installed windows 7 with media player 12, and all the albums with Greek characters that were fine before on vista (with media player 11) are now displayed with irrelevant characters. Any language packs/fonts i should install? What file type? Dumb question, but have you installed the Greek language pack? -- Speaking for myself only. See http://zachd.com/pss/pss.html for some helpful WMP info. This posting is provided "AS IS" with no warranties, and confers no rights. -- "Anteras" <Anteras@discussions.microsoft.com> wrote in message news:AAA197...

Excel 2000: File format of Unicode text files
In Excel it is possible to save a worksheet as 'Unicode text'. Is there a description of the file format of these unicode text files? The problem is that there are some quotes (") added, if the cells content e.g. a line feed or quotes. So there may be some additional cases, where unexpected content is added by Excel and this would be very helpful to know. Thanks -- Rolf Keller I don't think MS has documented their file format publicly. Your choices may be to do the experimenting yourself to deduce their format, or to use a macro to create the Unicode text file. Here...

Why do my pie charts have labels which say "add text"?
Using Excel 2007 and my template comes up with this add text label for multiple labels on the pie chart. Even when I save a new template it still happens. Why? ...

Landscape printing
Hello .. I am brand new to Visio and apologise if this is the dumbest question ever .. I am trying to print in Landscape mode, have the printer settings correct as far as I can see, have the latest driver for my printer HP Deskjet 5740 but it keeps printing in Portrait mode. Also sometimes it prints and other times it doesn't ... strange or what? Some help would really be appreciated. Thanks in advance, Abay check a print preview; may it gives a clue? try setting at "portrait"; sometimes they have been known to be reversed for some odd reason in some drawing setups a...

Subscripted text in the legend of a graph
Hi, I have been trying to write a legend in a graph which has some of its part subscripted. However, I have not been able to do so. Could anybody show me a way out. nure If your superscripts are just 2 and 3 (squared and cubed) then for toy axis header use something like y +ALT0179 or y+ALT0179 (digits on the number pad) to get y� and y� For other digits you need a fond such as Chemistry font (see http://www.scs-intl.com/frameload.htm?/chemfont.htm) which has sub and superscripts for all digits. So does the Calibri font in Office 2007 but they do not have sequential ASCII values. See...

EXTRACTING NUMBERS FROM A TEXT CELL
This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6EC75.288A0320 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello! Currently I am unable to download information from the accounting system = in a better format. So one line of information come into Excel in one = cell, hence, the example below:=20 =1B@1 0325=1B@1 OPENING BALANCE : .....ESTIMATED COST - = MATERIAL=1B@1< 813,936.29 There are two things I need to learn here: 1) How can I extract just the number.=20 1a) I tried t...

Selecting multiple sheets to print to PDF
Can you see something inherently wrong with this code which is being executed from 1 excel file on another: Workbooks.Open Filename:="c:\File_2.xlsx", UpdateLinks:=3 xlfile_drive = "c\" temp_file_name = "Savename.xlsx" Workbooks("File_2.xlsx").Activate Sheets(Array("Investment Models E", "Open Models E")).Select Sheets("Investment Models E").Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ xlfile_drive & temp_file_name _ , Quality:=xlQualityStandard, ...

Unwanted blank line in cell with wrapped text
Unwanted blank line sometimes appears in cell with wrapped text. Editing, Autofit height and width, and justify do not eliminate it. Forcing column width to be excessively wide makes it go away, as does reducing the font size (neither of which I want to do). What's going on? This only happens in some wrapped text cells. bbl If you uncheck "wrap text" do you see a little square box in the text where the blank line is? If so, someone entered a new line using ALT + ENTER. In that case, you can get rid of these boxes by Edit>Replace what: hit ALT + 0010(you won't se...

How can I print the username or computername from excel?
How do I do, when I print an excel file, to have the username or the computer name of the person/computer that is printing it? Thanks. ...

How do you print mailing labels???
HELP! I work on a Mac iBook, OS 9.2 & use MS Word 98 & MS Excel 98. I have a list of friends mailing addresses saved in an Excel Worksheet. I bought sheets of Avery Labels that are the 8660 format (1 sheet has 30 labels, 3 columns & 10 rows), to insert into my HP Inkjet printer. I don't know of a way to print labels from Excel (IS THERE ONE?) so I assumed I needed to do a 'Mail Merge' into Word in order to print the mailing labels.... The support folks at Avery only had support for Mac users w/ Word X, and I haven't been able to follow them to figure out how to g...

Exporting text from Word to Desktop
I would like to transfer a small amount of text from a Word document I have created to the Desktop to accompany and enhance a desktop background picture. I know you can download ones from internet so it is possible to create text there just how do you do it please..can anyone help? And do I need specialist software to do it?) You would need a software, but most computers come with a minimum of graphics capacity, so you might have Microsoft Photo Editor for example. If you double-click on your picture, it (hopefully) will open in whatever software you have available. Look f...

Default print settings
Hello, I am using Access 2007 on XPSP2 and an HP Deskjet 6500 printer. In Control panel the default setting for print quality is FastDraft. However, when I print from Access 2007 this is changed to Normal. Is there some way to get Access to use the default printer setting for print quality without having to manually set it each time I print? -- Thanks, Bob ...