More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
i want to use if Command in which 19 times If Function to be used for Example
of the Function is
=IF(A2="Bongaigaon", B2*40, IF(A2="Dhemaji", B2*100, IF(A2="Dhubri", B2*50,
IF(A2="Dibrugarh", B2*65, IF(A2="Golaghat", B2*50, IF(A2="Guwahati", B2*20,
IF(A2="hojai", B2*50, IF(A2="Jorhat", B2*60, If(A2="Kharupetia", B2*50,
up to 19 times
Hi - You really need to create a table with the 19 names in one column and,
in the column to the right, the vaues associated with each name. That would
...Incomplete Escaping Functionality??
I am in an app that needs to write out an XML document for transmittal to an
outside organization. All good and fine... I create the XmlDocument object,
append all my nodes, and values etc etc... and it all works.
Now I go to save the file... I tried two methods...
My.Computer.FileSystem.WriteAllText(filename, MyXmlDoc.OuterXml, False)
The problem comes in with XmlDocument.OuterXml. According to XML, there are
5 characters which need to be escaped... Ampersand, LessThan, GreaterThan,
Apostrophe and DoubleQuote. XmlDocument.OuterXml, esca...Can't Send Messages Until I Press F9 Key
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii; format=flowed
After I compose a message and click Send, the message does go its way
until I press F9 or choose Tools|Send/Receive. I'm using Outlook 2003 on
Windows XP. In case it matters, there's a toolbar for ZoneAlrm Outlook
Addin with Junk filters (I use the Zone lite firewall freebie). Is there
a setting in Outlook I need to set to automatically send messages?
Should I disable the Zone addin? If so, how?
---...SUMIF function not calculating from closed worksheet
We recently upgraded from Microsoft Office 2000 to 2007. Prior to the upgrade
each department would access a spreadsheet that would load data from a
common lookup spreadsheet
The loading process was performed as follows:
The lookup file and each department file would be opened to update the link
for that month and then saved and closed. When the department head would
open the department file, a question would appear asking if they wanted to
update the link, if they answered no the spreadsheet would open and display
the calculated data. If they answered yes, the file would o...excel, worksheet, set print area, position selection on printed pa
Office 07, Excel.
Print area is set, print preview displays selection, always on far left of
I want to choose the position on the page, eg centered or right aligned etc.
To get your printout to center on the page chose Page Layout, click the
Page Setup quick launch button (bottom right corner of the Page Setup group).
Choose the Margins tab, click Horizontal.
There is no command to right align a printout, but you can change the left
margin to force the printout to the left.
If this helps, please click the Yes button
"Eve Al...Clearing security settings
I am setting up a new server that will be home to GP
version 8. I am migrating from 7.5 to 8. I want to clear
out all users, advanced security, and standard security
settings and recreate them on the new server. Anybody
ever scripted this? I assume I want to truncate tables,
but I don't know which ones, other than what is show in
techkno Steps to remove Advanced Security (874401).
If you run a delete statement on the SY02000 table, it will remove all
settings, then you can run a reconcile against security restrictions and user
"Cindy Lange" wrote:
> I...catching enter key for multiple editboxes
I know that to catch the enter key I need to subclass the editbox control,
but I was wondering if there is a way to do this for multiple editboxes
other than to subclass each control? I suppose I could do one and then
create the others dynamically, but can it be done during design as well?
...Set default time zone for all users
Is there a way to make the time zone default to a certain value so that I don't have to go into every user and change it to the correct zone?
No. Each user must change their own timezone settings. I have no idea why
Microsoft do not pick up your computers timezone. Hopefully this will be
changed in a version 2.0 release
"Jack Black" <email@example.com> wrote in message
> Is there a way to make the time zone default to a certain value so that I
don't have to go into every user and change i...How do I set up a formula in excel that is the tenth root of 7 ve.
How do I set up a formula in excel that is the tenth root of 7 versus the
square root of 7?
try the formula =7^(1/10).
"kestig1" <firstname.lastname@example.org> wrote in message
> How do I set up a formula in excel that is the tenth root of 7 versus the
> square root of 7?
...Can I create sub-functions in a cross-functional flowchart?
Trying to create a template for my organization to map processes to. Goal is
to map the organization to the 'function bars' in Visio's cross-function
flowcharts. However, I would like to create some 'sub-functions' for lower
organizational elements (i.e. divisions under a department). Is this
...Unable to enter correct product key
I have purchased a Mac G4 PowerBook and installed my Microsoft Office
(student and teacher edition). Not understanding the significance of
the Product Key, I entered a code that I have already used on another
computer. Now I am unable to open Microsoft Word on my hew computer
because I also have the same product key used on my old computer. I
have three product keys. How can I install the program in my new
computer using the correct product key?
In article <email@example.com>,
firstname.lastname@example.org (george) wrote:
> I have purchased a Mac G4 PowerBook ...Can I set my custom views on Pivot table
I want to get Pivot table data on my invoice, is it possible to set custom
views so that I can get Pivot table results on invoice format, I've tried
views that offer excel but it doesn't offer custom views
...Prices and cost Set to zero when exporting a new store
When I export a new store with 1.2.085v from headquarters all the cost and
price information is set to zero. I have seen that there is a fix for 1.3v
but i cannot seem to find any other fix for our version. Any suggestions?
Just run worksheets to update the cost and price.
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.
Joe Gonzalez wrote:
> When I export a new store with ...MOD Function: MOD(7.0,1) = 1 Why? and how to work around it.
I'm using Excel 2003 spreadsheet, but I've tried this in Excel 2010 &
OpenOffice.org. A similiar error occurs.
You can see that I've also used the Microsoft suggested workaround but
to no avail.
Does anyone have an answer or possible suggestion.
A B C
Qty MOD(Qty,1) number-(INT(number/divisor)*divisor)
Equiv. = Qty-(INT(Qty/1)*1)
$A$2 5.0 0.0 0.0
SUM($A5,$B$2) 5.1 0.1 0.1
SUM($A13,$B$2) 5.9 0.9 0.9
SUM($A14,$B$2) 6.0 0.0 0.0
SUM($A15,$B$2) 6.1 0.1 0.1
SUM($A23,$B$2) 6.9 0.9 0.9...Discharging a message box with return key
I handle PreTranslateMessage, look for VK_RETURN in a edit control, the SendMessage() to a button press handler, OnApply().
The effect is, when the user presses RETURN in a specified edit ctrl, the 'Apply' button is pressed programicly.
The OnApply() method issues a MessageBox() system modal. Pressing enter to discharge the message box causes the message box to disapear( as expected) but then for some reason PreTranslateMessage receives that return key press, and calls OnApply() again...
Clicking OK in the message box works as expectred.
Why do i see the return key press in ...Set Primary supplier to the lowest cost
Has anyone worked our the SQL to set the primary supplier in Item table to
the lowest cost from supplierlist? We now have a large number of items where
the price fluctuates and it would be really useful to 'order from the primary
supplier' knowing that it was the lowest cost.
When you create a PO select the order from lowest cost supplier option.
Microsoft Business Solutions Certified Partner.
Microsoft Retail Management System
Microsoft Small Business Financials
"David" <David@discussions.micr...storage memory vs program memory: how to pre-set?
I need to assign more KBs to Program Memory.
I know that from user interface I can do that by going to:
Settings--> Control Panel--> System-->Memory, and moving the slider to the
My question is how to pre-set the new slider position so that at boot is
already at the wanted value?
I have tried to play with Registry Editor and making comparisons between the
registry values before and after, but none of the HKEYs looks to be impacted.
Where can I pre-set this value?
You can set the FSRAMPERCENT environment variable in config.bib. ...Macro or Function to make text size to suite text Length?
I would like to find Macro or Function that will make text size to suite
eg. if the first cell has "bill smith" then the text size would be 10.
But if you had "Christina Vandermear" then the text size would be as small
as 7 in order to fit in that same size cell.
I know it's a bit of an odd request, but is there a way to do that? thanks
only possible with VBA. You may download the following addin for this
extension of the conditional format (as Excel's build in format can't change
the font size):
http://www.xldynamic.com/source/xld.CF...Functionality disabled in junk mail
I believe that disabling functionality in junk mail is extremely worthwhile.
Unfortunately, if junk mail is moved to the deleted items folder,
functionality is restored. This exposes us to the exact threat you are
trying to avoid by disabling the functionality.
I suggest that some flag be saved with mail identified as junk, and that
flag be checked, and the user be given a warning before enabling
functionality. Further, no flag or check is necessary if the user identifies
the mail as not junk, or moves that mail to the inbox.
This post is a sugg...Page settings get lost ?
I have selected "Landscape" in the page settings of a report and then saved
Every now and then, it appears to forget this setting when running the
Anyone know how to avoid this problem ?
What version of Access is this?
If it is 2000, you need to apply the service packs. You can download them
Be sure to get the JET sp as well as the Office sp.
You will also want to turn off Name AutoCorrect:
More info about this mis-feature:
If 2007, there's ...Date function
I have a date in a field 03/25/2006...I would like to change this date to
only show day and month of date 03/25 . I think I can use the Day and Month
functions to pull out the day and month from the date.
Can someone help me with using one fuction to get day and month from this
Thanks for you help
You could just re-format your cells with the date in.
Select the cells
Open up the format cells dialog (will vary depending on your version of Excel)
Select 'Custom' from the list of formats.
In the 'Type' line, type in 'mm/dd' (without quo...Automatically set categories on events
can anyone tell me a way to automatically set categories to events by
rules? Not the colorize of events, just the "real" Categories.
Thanks for your help.
email@example.com <firstname.lastname@example.org> wrote:
> can anyone tell me a way to automatically set categories to events by
> rules? Not the colorize of events, just the "real" Categories.
I use the "assign it to the _category_ category" action.
I can't get this function to work. I followed MS' instructions in the Help
file to no avail.
The A2 cell is date formated not text.
What result do you get when you try it as you described? If you are getting a
#Value error in A1, try entering =iseven(2) in a cell. If that returns #Value
as well then you need to install the Analysis Toolpak. To do this, in Excel
go to Tools->Add-Ins, check Analysis Toolpak and click OK. If you are having
some other difficulty please let us know....Exporting add-in containing dll functions to other computers
I developed an add-in for excel 2000 containing wrapper functions for a
dll I made as well. Now I'm trying to export this add-in to another
computer by copying the add-in to the other computers add-in folder(ie.
C:\Documents and Settings\"YourUserName"\Application
Data\Microsoft\AddIns) and placing the dll I developed to the windows'
system32 folder. Even though I do this something goes wrong and I get
only an error report #Value! for every function I try to to use. The
add-in works just fine on the pc I developed this add-in on.
If you have any idea please...Macro Security Setting not applying ...
I have a workbook that will sporadically lose it's ability to run macros
even though the macro security setting is set to 'medium'. i.e. - no message
box comes up when opening the file and when trying to run any macros, the
"cannot run macros ..." box comes up.
The only way I can fix this is to open the file, select macro-security
setting "low", save the file, open it again, and then return the setting to
This file is out on a shared drive and many of my users need to access this
- so the quick-fix noted above really isn't...