ROUND Function with other function
I have this formula:
and the results shows me for example: +11.6 but what I really want t
show is +12.
I've been trying to put the "Round" function at a few places in th
formula but it doesn't work.
The closest I got was with this formula:
where it showed me 12, without the "+" sign before....
Can anyone help me ?
Outapin's Profile: http://www.excelforum.com/member...Returning a range from an inner function
I have a range of data, which has had the DOLLAR() function performed on it.
I would like to get the total of this range using the SUM() function. doing
SUM(F1:F4) will not work, so I need to convert the data into values that
will work. The VALUE() function is perfect for converting the data into
values that will work for SUM(), but the formula SUM(VALUE(F1:F4)) does not
work because VALUE() will not accept a range as a parameter (and also does
not return a range). I need to perform the VALUE() function on each cell
before submitting it to SUM(). There must be some way to do this,
cons...JustifyString function problem
I'm using the "JustifyString" function (from Stephan Lebans) to right
justify three columns in a ListBox. Two of them are working fine ... one's
a simple number (long integer) and the other's currency. The third causes
an Access 2003 crash!
That third column is a long integer which is a link to the autonumber field
in another table.
Both tables are in the query as I need columns from both tables in the
If I change the JustifyString to reference the autonumber field in the other
table, I still get an Access crash.
I didn't review the Access er...How do I create custom postcards in Word 2007?
I want to create my own postcards using the right size and type of paper for
This depends entirely on your printer. Can it handle the heavy weight
of card used in postcards, and can it handle the unusual size of a
On Apr 18, 2:54=A0pm, Create Custom Postcards <Create Custom
> I want to create my own postcards using the right size and type of paper =
Perhaps the easiest way to start is to get some Avery (or similar) postcard
stock, which will have two postcards per sheet. Then find the a...Check Box in Excel #2
I need to create a check box in excel so that when I click on the box,
a tick mark should come in the box.
Can anyone please help.
You can show the Forms toolbar and click on the checkbox and draw it where you
want it on the worksheet.
> Dear All,
> I need to create a check box in excel so that when I click on the box,
> a tick mark should come in the box.
> Can anyone please help.
Please check your other post for multiple answers. We discourage multi...How do I check to see if still internet / ftp connected
I am using wininet library to download data from the internet. I am using
the CInternetSession class and the CFtpConnection class to perform ftp. My
question is I would like to know how can I check to see ofthe
CInternetSession instance one used is still connected to the internet, and
how to check to see if the CFtpConnection instance that is till connected to
an ftp site?
Are there simple function I can call on each instance to see if each is
is this helpful ......
"steve" <ste...automating functions
I am a complete novice at CRM 1.2, but want to be able to create, for
example, a workflow process that will monitor the CSR's and the queues and
automatically assign a new case to the least busy CSR.
Any input would be appreciated.
Thanks in advance
Please tell me what I would have to do and with what tools in order to create
such a workflow process.
> I am a complete novice at CRM 1.2, but want to be able to create, for
> example, a workflow process that will monitor the CSR's and the queues and
> automatically assign a new case to the lea...Pivot Table Creating New Columns that Subtract Two Existing Columns
I have a pivot table that has rows for account numbers and columns that
represent months. The data section has the year to date amount for
each account number. Is there a way to create a new column that
subtracts one months year to date value from the previous month year to
date value in order to come up with the monthly value? Also, is it
possible to have this only apply to certain rows? For instance, the
balance sheet accounts are year to date amounts but income statement
accounts are monthly amounts.
Any help or advice is appreciated.
Click on one of your months.
Then, go to...Returning a CHAR from a function
I have the following function that returns the path of where the
program was run from.
However I cant seem to return the butter as a CHAR. The code works if I
use it in a procedure but not where I need to return the variable CHAR
char buffer[_MAX_PATH]; //declares maimum path
//opens window maximized
//_getcwd(,)gets the current working directory
// #include <direct.h> //needed for current working directory
/* Get the current working directory: */
if( _getcwd( buffer, _MAX_PATH ) == NULL )
perror( "_getcwd error" )...Downloads checking account information into my Money 2006 Savings
I purchased and installed Money 2006 today. I have a problem. Everytime I
import from my internet checking. It puts it into my Money savings account.
Any way I can redirect the imported information into my checking file?--
In microsoft.public.money, New Money 2006 user wrote:
>I purchased and installed Money 2006 today. I have a problem. Everytime I
>import from my internet checking. It puts it into my Money savings account.
>Any way I can redirect the imported information into my checking file?
Is the problem you have the one described in
http://support.microsoft....Voided payables checks
A payables check that is voided today for a check written in a prior month
should stay in the bank reconciliation until the month(date) that the void
posts. If you have prior month bank reconciliations to do the check will not
be in bank reconciliation but the check amount will stil be deducted from
general ledger. This difference may be very difficult to find if this check
goes back a few months. The only thing you can do now is to manually keep
track of all voided checks.
Thanks for the suggestion. This feature was added in the last release (version 9) of Microsoft Dynamics GP.
Suppose you have a very complex and long function that is also subject to a
condition, then you will/can have something like:
=if(condition(complex function), complex function, other complex function)
It can have more lines in the formula bar, so readability below 0 Kelvin.
Is there a way to 'name' a function?
=If(condition(myfunc = complex function), myfunc, other complex function)
With kind regards,
Yes you can put a formula into an Excel Name (the same as you can give
a range an Excel Name. Very powerful it can be too. Do a Google fo...Turning Off Error Reporting using API Functions and VB
We want to automatically turn off the error reporting options using Windows
API functions for the following functions area
Click on Start, Settings, Control Panel, System, the Advanced tab and Error
Reporting (at the bottom of the screen), which launches the Error Reporting
screen. Another way to get to that screen: Open My Computer, right-click on
Properties, click on Advanced tab and Error Reporting.
Any assistance would be welcome.
It's not a program's call. It's the user's decision.
I have put together a spreadsheet to find codes, states, descriptions. It
finds the data by dates.
Columns are: Dates, Codes, States, Descriptions
If I put in a date it matches the code, state and description.
My problem is that if I have 2 dates that are the same it will only match
the first date it can find. What kind of formula do I need so that it will
output the second or third date data.
Thanks for your help.
If you need a copy of the spreadsheet please let me know.
How many rows of data do you have?
Microsoft Excel MVP
"Melanie" <Melanie@discussio...Obtain MICROSOFT and CISCO Certificaitons Without Exams(Pay After Check Results)100% Passing Gaurantee
After Check Result.......100% Passing Gaurantee In First
Attempt.......Need Not Tto Give Exams By Urself
I m going to tell you the fastest way to get
MICROSOFT,CISCO,COMPTIA,ORACLE,SOLAIS certified without efforts......
friends i have five vue and prometric testing sites here in
INDIA.......so, i will do the exams on the behalf of the candidates,
make them pass and charge some extra amount from them.........
see i need ur some details then i will book ur exam on my testing site,
make u pas...If Function Function
okay. So I am trying to workout a formula to compute a commision earning.
Basically, if X amount of new business is made, then X*Y (corresponding
Commision rate percentage), but if new business =<X, then X*Y (Commision rate
percentage that is true).
Problem is, it's super confusing...anyone have any suggestions?
See if this helps:
Microsoft Excel MVP
"aetejada" <firstname.lastname@example.org> wrote in message
> okay. So I am...DateDiff function throwing error in Where clause
I have a set of queries that generate dates and want to use DateDiff to
select those records with certain dates are greater than others. The
following clause keeps giving me an incompatible data type error:
WHERE DateDiff('d',[From date],[DatumStvoreni])>0
I have the exact expression in the SELECT clause and it show positive and
negative integers just fine, but when I add this test, I get the error.
There are no bad values in the dataset, I've looked, and when I export the
DateDiff column to a temp table and run a query on that, it works fine. Only
when I use t...Creating a dynamic IF statement
I have data in two sheets. I want to create an IF statement in the second
sheet that has the ability to scan the first sheet for a value. If it finds a
match to a value in the second sheet, deposit the value into the
corresponding cells of sheet two. My example:
User B 12/10
User C 12/15
In this example, I will have the IF statement in column B of Sheet 2. I want
the IF statement to scan column A in sheet 1 for matches to column A of sheet
2. If it finds a match, place the corresponding value in column B (in this
case, it wou...Create Org. Problem
I want to add a new organization to my enteprise server. After i go through
the create organization wizard, the new company shows a pending status.
After I click on refresh it disappears. How can i resolve this issue??
I have had a similar problem (in my case though the wizard told me that the
creation of the new org. failed...) and it seem to have appeared after
applying RollUp4. The problem seems to be that the wizard can't add new
users to the AD OU, so you might have to turn of this feature.
You can turn it off by changing the reg entry "AutoGroupManagementOff"...Outlook 2002 Change Password function
I want users to be able to change password from the Outlook Login Page, but
it does noet seem to work.
Outlook 2002 Sp1 and Windows Server 2003 (AD) and Exchange 2003 SP1
Important: Outlook client is not member of the domain...
There are not many Microsoft Articles about this.
Menko den Ouden
Menko den Ouden schreef in deze nieuwsgroep op 23-6-2005 15:28:
> I want users to be able to change password from the Outlook Login Page, but
> it does noet seem to work.
> Outlook 2002 Sp1 and Windows Server 2003 (AD) and Exchange 2003 SP1
...timing a function
Good Morning All,
I've writen an MFC C++ application, under VC++6.0 .
How can I check how much time it takes for a specific function to complete?
I need to know how many miliseconds one of my function call takes.
Thanks very much in advance,
If your accuracy requirement is in ms - use GetTickCount.
Nish [VC++ MVP]
"dududuil" <email@example.com> wrote in message
> Good Morning All,
> I've writen an MFC C++ ...Creating Profiles
For some reason, I just cannot work out how to create
I'm using Win 98, Outlook 2002, have gone into control
panel, Mail, added three profiles and ticked "When
Starting Microsoft Outlook, use this profile:
Prompt for a profile to be used"
But when I open Outlook it only goes to my main profile.
Am I confused as to what Outlook can do, is the same as
Outlook Express, where you can have three profiles, choose
which one to use, and all email goes to the
correct/different email inbox, all folders are different
depending on what each different profile user has set ...Check box on continuous form
I have a continuous form listing available parts. I need to be able to
select a part from the list using a check box (or something that will give a
true if selected). I tried an unbound check box, but when clicked, it
selects all of the records in the form instead of only the one record.
Am I missing a setting? or what can I do to create this selection
capability. (which I am then using code to complete the action I need)
On Dec 19, 1:13 pm, Design by Sue
> I have a continuous form listing available parts. I need to...Charts created in Excel 2003 are not showing up in excel 2007
I have several charts that are displayed as their on worksheets in excel 03
but don't show up in excel 07 how can i fix it so that these charts will
> I have several charts that are displayed as their on worksheets in excel 03
> but don't show up in excel 07 how can i fix it so that these charts will
I had this exact problem when I upgraded from Excel 2003 to Excel 2007 on my
Vista (Home Premium) system. I couldn't work out what the problem was and had
given up trying to solve it... However, I somehow managed to fix...fully depreciated Fixed assets still have book value
We had some assets that were imported in at incorrect life. These assets are
now showing the fully depreciated flag of Yes but still have a net book value
(we use SLM for depreciation).
How do I book the remaining depreciation for these assets?
I had a client that had this problem because they hadn't calculated the
depreciation correctly in Excel before we imported the assets. I believe
what we did to correct the situation was to just change a depreciation
sensitive value on the "Book" record and then change it back. This caused
the application to recalculate the deprec...