Multiple "IF" functions one one cell returned from different cells
OK, maybe that wasn't the best way to ask the question...
I need to create this scenario:
Question: "Lot Size?" Answered by "X" under "Small"(A3) "Medium"(A4) or
If (A3) = "X", then (J2)= 500
If (A4) = "X", then (J2) = 600
If (A5) = "X", then (J2) = 700
Obviously, these function will have to recide in the J2 box. I can get it to
work individually using the "=IF" function, but how can I insert multiple
"=IF" functions into the (J2) box?
I have tried using the "=OR"...Delegate Permissions #2
We have a 2000 domain (sp4) and exchange 2003 sp1. Remote
administrators in our schools are delegated permissions to
fully manage their users.
Previously, when we were running Exchange 2000, everything
worked fine. They could add/delete users, mailboxes, smtp
After our upgrade, they are getting an error ONLY when
they try to add an smtp address to a user ...
Access is denied.
Facility: Win 32
Microsoft Active Directory - Exchange Extension
We have read and followed
we removed and redelgated perm...Getting a macro to run a formula in a cell?
I know this is simple but... how can I get my on-screen button which ha
a macro assigned to it, to put a formula in a cell. .
In other words, I made a "Reset" button that sets many cells to "0"
others to certain numbers (like 450 or 50) and two others need to hav
a formula. When I set the code in the macro to:
ActiveCell.FormulaR1C1 = "b3*.0035"
It puts the above formula in the cell instead of computing the answer.
All help is appreciated. Please help oh mighty Excell Gods
Message posted from http://www.ExcelForum.com
...Exchange 5.5: 1 site, 2 servers
My continued quest to move to a new server with the Ed Crowley Method.
I have added the new server to the existing site. Some mailboxes have
been migrated over and those are working fine. The IMS was setup on the
new server duplicating the settings of the IMS on the old server. The MX
record (out where our DNS is hosted) was updated and the new server
given a lower cost than the old server. Both IMS connections are still
running. From what I can tell from the event long, the new server is
accepting new connections (A new TCPIP connection has been made.....).
If I send an email to a pe...Lock cells conditionally formatted in 2007
I conditionally formatted a range of cells so that a cell changes color if
the content =x. How can I lock the cell if it contains an x?
The scenario is an employee schedule. I put an x in the cell of days they
can't work. But I've deleted the x by mistake and scheduled the employee. I'm
hoping the color change will help me but would like the cell to lock if I put
an x in the cell. Then I'd need to know how to unlock an individual cell if
the employee changed their mind.
I've seen posts about conditional format\custom but can't find it in 2007.
...unwanted formula in cell instead of calc
I have numerous formulas in the cells of my spreadsheet that return
correct results. Suddenly some of the cells I am entering formulas into
display the formula instead of the result and I can't get rid of it. I
have tried toggling Ctrl+~. The formulas appear identical to adjacent
ones that work fine. I have tried pasting the format from working cells
into the malfunctioning cells. No help. Any idea what's going on?
...Why Are My Posts 1 Hour Ahead
I just noticed that the time of my posts is one hour ahead of everyone
else's. I'm using Outlook Express with Windows 98 Second Edition to read
this newsgroup and the time on my computer's clock is correct, and is the
time that appears with my posts. I recently reloaded all of my software so
I probably missed something because I know this was not a problem before the
reconfiguration of my computer.
That was easy enough.
"Paul Corrado" <firstname.lastname@example.org> wrote in message
> I just notice...Syntax to write a null value inside a sql Insert string?
Is there a way to represent the null value as a string (destination: varchar
column) the way that the following string represents a null value for a
Public Const cNullDate As Date = #12:00:00 AM#
Writing to an Access 2003, (conversion) table with VS2005 in VB.NET.
Within the table is a field named VSubType1 with a validation rule of: "In
('P','O') Or Is Null"
The declare/move/insert statements look like this (shortened example):
Dim intRecNbr As Integer = 0
Dim VSubType1 As Object (defined as Text 1 column in Access)
Dim V1...Pivot Charts, hiding field values in second level filters?
What I have is a Pivot Chart / Table, where I have multiple filters on
the data. For example I have Leagues, Teams, Players.
What I have are Leagues and Teams in my page fields and Players on the
series axis. This allows me to select the League I want to look at and
then the Team within that League. I can then select multiple players
(1..n) from that to view the data on. (Assume data is a monthly
statistic of some sort).
If my data were
League Team Player Jan 05 Feb 05 etc.....
L1 T1 P1 5 6
L1 T1 P2 3 ...Protecting single cells or a range
How can I protect a single cell or range so that the rest of the sheet is
able to be accessed. I can only see options to protect the whole sheet or
Thanks in advance.
Good afternoon Ant
Protecting a worksheet only protects the cells that are locked. In a
new worksheet all cells are locked by default. Unlock the cells you
want the users to be able to edit via ctrl + 1, Protection and uncheck
the locked box. This can be done an many selected cells at once. Then
apply protection with Tools > Protection > Protect Sheet.
---------------------...RMS 1.3 #3
i read in discussion board that RMS 1.3 will only work with windows 2003 and
XP. Is it just for the work stations or our server has to be also 2003 and
...Changing SQL Server for CRM 1.2
As my SQL server is currently on its last breath I am in the process of
moving our CRM 1.2 databases to a new dedicated serever. I have detatched the
databases from the old server, copied the files to the server and attached
I have then gone into CRM deployment manager and changed to the SQL server
to the new server.
That all appears to work fine, no error messages. But when users try to
access the CRM system they get an error and the CRM server event log fills
with error messages. A few are listed below:
dmLog: Failed to execute the SQL batch in the file sqlbatch.sql.
MSCRM P...Adobe Acrobat #2
Is there a way to import information from a pdf file into an Excel
spreadsheet? I know I can do it from word, but the information should be
seen in columns and rows and possible edited.
You can Insert it as a picture/object, but Excel cannot read the data
content of the file into cells for editing... At least not on its own. One of
the reasons for a .pdf is to prevent others from changing the content.
> Is there a way to import information from a pdf file into an Excel
> spreadsheet? I know I can do it from word, but th...Append from 1 table to 2 tables
I have a reservation application that I have obtained reservation data from
an email message (daqta from which is entered into the tblWorking table). The
email shows travel information either one-way or round trip. One way is
referenced by the literal "PRC-PHX". Round trip is referenced by the literal
"PRC-PHX-PRC". Depending on the O/W or R/T direction(s), I insert the number
one (1) for O/W or the number two (2) for R/T.
The form used by the application has a main form (Reservations table) and an
embedded subform (ReservationDetails table). The main form h...Cell reference, dragging across
My question is pretty simple, and if anyone knows the
answer I would appreciate a response.
If my cell reference is =b7/c8, and I want to drag the
reference cell across and change the cell number but keep
the letter constant, is that possible?
...Akuzuki 1 1/2" Galvanized Hardwood Flooring Staples (5,000)
Best deal: http://discountadvisors.info/index.php?id=B001N1K28K
Compatible with Bostitch MIIIFS; True Value 407619, Akuzuki.
Akuzuki Top Quality Pneumatic Hardwood Floor Flooring Air Cleat Nailers:http://discountadvisors.info/index.php?id=B000Q38KOO
...2400 Accordion MERV 10 Aprilaire and Space-Gard Replacement Filter (2 Pack)
Best deal: http://thediscountdatabase.info/index.php?id=B000NMJ2WM
Reaches 99% efficiency on particles 5 microns or larger. Improves efficiency and increases longevity of HVAC systems when properly used and maintained. High efficiency filter media collects small dust particles before they can collect on your coils. This product is listed and rated by Underwriters Laboratories as U.L. Class 2.
2200 Accordion MERV 10 Aprilaire and Space-Gard Replacement Filter (2 Pack):http://thediscountda...CRM 1.2 compatibility with 'MAUS' business and accounting software
Is Maus compatible with CRM 1.2?
Does anyone know?
...In Excel, how can I let 1 * a = a?
Say I have two cells, one has a value (0 or 1), and the second has a
text abrevation such as a or b,....etc.
When I type A1*B1, for example, I get #VALUE! stuff!!
How can let it come out like this?
=IF(A1, B1, A1)
should do it
or more explicitly
=IF(A1=1, B1, 0)
Juan Pablo Gonz�lez
"Michael" <email@example.com> wrote in message
> Hi everyone,
> Say I have two cells, one has...Office Setup for 1 user
I have 3 users on my computer. I am using Vista Business and office 2007.
2 of the three users use office 2003.
My question is this.
Is it possible to install 2003 for the other 2 users and 2007 just for me.
I know some programs allow yoou to install per user but don't know if it is
possible with office.
You need to read the terms of the end user license agreement (EULA) that
came with your software. Even versions of Office have different terms.
If you can't find it, you may be able to look it up here:
Find End User License Terms for Microsoft Software Licens...CSV elements don't get split up in cells
I recently installed a German version of excel and now when I open m
CSV files they don't get seperated anymore by the commas. The whol
line is just written in one cell.
When I had the US version installed the data was split up after eac
comma and distributed into the corresponding cell.
How can I achieve the same thing in the German version
Message posted from http://www.ExcelForum.com
You could try renaming the file to .txt rather than .csv When you try to
open this in Excel it will start the Text Import Wizard which will give you
much more control over the import of th...Add timer to a dll #2
I have a regular MFC dll. I want to add a time to the application class. Is
it possible and how?
"Galia" <firstname.lastname@example.org> schrieb im Newsbeitrag
>I have a regular MFC dll. I want to add a time to the application class.
> it possible and how?
i think i gave you a answer to this on some another NG.
You should work with a hidden window to get timer
messages. As far as i know, this is the most effective
method. Maybe someone else has a better s...Merge / Collate Workbooks into 1 workbook
Grateful for help with this urgent problem, which requires automation:
I've got 50 workbooks
Each workbook is named after an Area
Each workbook contains:
Cell A1, Column Header 'Area'
Cell B1, Column Header 'Zip Code'
A2 to unknown number of rows contains the Area Name
B2 to unknown number of rows contains different zip codes relating t
I want to merge/collate all this data into one workbook. Please se
AREA ZIP COD
Chi...restrict value entered into cell
Is there a way to restrict user to enter negative values into a cell?
Select the range (e.g E34:E56)
Data > Datavalidation > Custom
enter this formula
Followup to newsgroup only please.
"ericlye" <email@example.com> skrev i en meddelelse
> Is there a way to restrict user to enter negative values into a cell?
...Limit a field to 3 digits 1 capital letter 1nd 2 numbers
I want to use Data Validation to restric user for data entries
I need that the user use this format in column B: 1 letter in capital
and 2 numbers like A02 or S31 or T11 or M45 .....
I have try many custom formula without success
I would also would like that within a range in column B that it would
be without duplicate
Thanks for helping
Le 2011-12-13 10:50, jean a �crit :
> I want to use Data Validation to res...