Adding if to Average If Array function
I recently had help understanding the following formula
Thanks to Luke M, Pete UK and David Biddulph who provided the explanation.
I've now been asked to add to this formula so that if either Q3 or Q4 is
greater than 4 then the average cannot be lower than 3.
Q1:Q35 is the named range score.
This is really complicated because I still need to have an average and I'm
thinking that the If part is non array but the average part still needs to be
Can you mix and match ...I am looking for a function for linear interpolation
I am looking for a function for linear interpolation
Look in HELP for the LINEST() function
Microsoft MVP - Excel
"azad" <email@example.com> wrote in message
>I am looking for a function for linear interpolation
...Can I use the NOW() function in a formula?
I have a cell B1 that has NOW() time and another cell B2 that has NOW() date.
I am trying to have data from another cell F1 brought in to the destination
when a given date and time occur.
This formulas does not work.
The Clock is continuously active / always changing.
Any suggestions would be appreciated. Thanks.
The NOW() function returns both a date and a time. Even if you format the
cell to display only date/time, all the data is still retained. NOte that if
you did want just the d...MSCRM Call Scheduling Add-on
Does anyone know of any add-on to CRM 4.0 that will help my call
center staff better schedule their calls? If they each manage, say,
500 accounts, then what I want is a regular 45-day call schedule and a
nice easy-to-digest view in CRM that shows them which calls they need
to make for the day etc.
...Slow load of first node, xmltextreader
I have a problem with reading a xmlfile from a url. I am confused by
the long loading time of the first node.
When the first node has been loaded, the rest of the nodes is parsed
I am on a c# 2003 environment.
The url returns an xml of appr 80 kB.
It takes 1,5 seconds from first,start to first, stop.
It takes appr. 0,5 seconds to generate the xml on the remote host.
I'll be very happy for any assistance on this!
// Gets the xml from the Url using XmlTextReader
XmlTextReader reader = new XmlTextReader(sea...Sum function
Operating System: Mac OS X 10.5 (Leopard)
I am trying to put together a spreadsheet for a business plan and am having problems with the autsum and autofill functions. Firstly, even though I do a simple autosum, if I change a value in a cell, the sum does not change. Secondly, if I try to autofill across columns, the values of those columns simply mirror the value of the first. In other words it copies it. I am at a loss how to get round it as I have been working w Excel for years and have never had this problem. I have experimented with a new worksheet with ...Need help with correct function or input for this problem/scenario
I have a situation where I am creating a borrowing base for a company. (I am
going to shorten numbers to make it easier.)
There is a $300 loan.
Type A loan can borrow up to $300.
Type B loan can borrow up to $150.
Type C loan can borrow up to $50.
I need a formula to input in excel that will give me a borrowing base for
type B and C loans. For example, to borrow in type B loans, I have to check
1-what's outstanding on the entire loan.
2-what's outstanding on type B loans.
3-Take those two numbers and figure out what can be advanced under the
answer to those questions. (I.E. $2...sum function usin an IF statement
Bit short on detail, but maybe
as an array formula, committed with Ctrl-Shift-Enter
again an array formula, where rng1 and rng2 are the same size.
(remove nothere from the email address if mailing direct)
"jimk" <firstname.lastname@example.org> wrote in message
...Using Filter string with IF function
Is there a way to use a filter string with the IF function?
I have a spreadsheet that looks like this:
Invoice No. Invoice Date Invoice Currency Invoice Value
1 dd/mm/yyyy USD 1234.56
65 dd/mm/yyyy USD 2345.67
74 dd/mm/yyyy EUR 3456.78
88 dd/mm/yyyy USD 4567.89
when I filter on the currency: is there a function such as
Assuming row 1 are t...Loading Great Plains on Citrix
Is it feasible to load more than one instance of Great Plains on a Citrix
Server? So that:
C:Program Files/Microsoft Business Solutions/Company1/Great Plains/
C:Program Files/Microsoft Business Solutions/Company2/Great Plains/
This is recommended if each company uses different mod forms and reports:
But if this to point to company a or b - you can configure this with Great
Plains security for which users can access what company when loggin into GP.
"Tremor Olaes" <TremorOlaes@discussions.microsoft.com> wrote in messa...Sum Function (was summing 13 cells to the left)
Trying to compose a formula that will only sum 13 cells to the left (13 months of data). When columns are added, I still only want to sum thirteens months of data. Can this be done without constanty changing my formulas? Make sense
see my reply to your old post
Neil S. wrote:
> Trying to compose a formula that will only sum 13 cells to the left
> (13 months of data). When columns are added, I still only want to
> sum thirteens months of data. Can this be done without constanty
> changing my formulas? Make sense? ...Another Issue With A Function
Ron Rothstein suggested and I used this function in my Excel 2003
Public Function QBRushYds(W, Q)
QBRushYds = Worksheets("Week" & W).Range("C2").Offset(Q).Value / 10
In Worksheet Totals Cell B56 thru B59 I have the following four
In Worksheet Week1 Cells C3 thru C6 I have the following values:
The function correctly calculates the values:
If I change any of the values in C3 th...Another MFC extension DLL problem
I have an entry point defined like this:
#define _UL_EXT_CLASS _declspec(dllimport)
#define _UL_EXT_CLASS _declspec(dllexport)
void _UL_EXT_CLASS AttachToUtilityLib(LPCTSTR pszString)
When I try to link the dll to another extension DLL, MyMessageBox is
unresolved. If I take out the LPCTSTR parameter, it links fine.
What could be wrong here?
Maybe it's a name mangling issue, are this DLL's both C++ ?
I assume you use different defines for your two DLL's otherwise you may have
"David W. Simmo...And function into If function
I´m trying to get this function to work. But I´m getting an error message.
=If(and(100/I6)*I7>101); I7<I6; 1; 0)
What the function is supposed to do is to detect peak values in chart table
that are measure errors from a measuring intrument and count every peak as 1.
This is how the function is ment to operate:
If the percent of the difference of the rise from the former cell to the
next cell in the sequence of data is larger than 101% AND the value of this
cell is smaller than the former cell then true=1 False=0
Im using a norwegian version of excel and I´m no...Outlook 2000
I unfortunately, deleted a dll file on my computer. It
happend when cleaning it up after a virus attack. Outlook
2000 is not installing again correctly. While attemtig it
I get the error message:
Failed to register a VB Script DLL. Reinstall or run
Regsvr32.exe Vbscript.dll to self register. The
key "DisplayName" is either missing or has an incorrect
value. [File c:\Program Files\Microsoft
Office\Office\Forms\1033\CNFRES.CFG, Section Description]
The article which was to solve the issue is here.
I already followed the steps in it;...Rank Function? #2
Why would my RANK function be returning #DIV/0! ????
Didn't know this was possible. Anybody run into this
> Didn't know this was possible
It isn't - so Excel is saying that you are trying to do the impossible
Your code will probably need to check for and exclude zero values
Message posted from http://www.ExcelForum.com
...distribute mfc42.dll with the app?
My app crashes on win2003 server, but if it will work if I copy over an old
mfc42.dll to my app directory.
Is it a good idea to distribute mfc42.dll with my app? (I checked the
mfc42.dll of Win XP against the one of Win2000, they seemed to be
It's OK to distribute this file, but you should localize it to your
application directory so that it doesn't mess up any other applications that
might get installed. You're right, there are a few versions with the same
name on the DLL.
"Wanjun Yu" <email@example.com> wrote in message
...Using C# dll as COM in an MFC application
I have written a C# dll in VS2005.
One interface and class are exported using Interop Services.
I want to use this c# dll in my MFC application, using VS2003.
It compiles after I imported the dll to my MFC app.
On runtime I get class not registered HR error in my MFC project.
I use the code as follow:
_NewActivationPtr myActivation = NULL;
HRESULT hr = myActivation.CreateInstance(__uuidof(NewSupernaActivation));
I don't what to do.
Do I have to use GACUtil to register?
If I want to use GACUtil do I have to sign my project?
Trying do it had failed, because my third party librar...Hlookup function
I am currently creating a page that has a column of calculations in it.
The calculations are amounts of Future options. at the bottom of the
column I calculate an average 6 month total by simply suming 6 months
into the future. The question I have is how do I automate the Total sum
number at the bottom, because every time I update my worksheet I have to
redo all my calculations because the previous months value is now 0
because there is no future value anymore, so I have to rename my range
and do my calculation over again. I originally thought of the Hlookup
function but I can't get it to ...Basic IF function help needed
This is a multi-part message in MIME format.
I'm using Excel 2002 for the first time and trying to place a function =
into a cell. I 'm using IF(N44=3DL, M44-L44, L44-M44) .
Which is supposed to mean If the letter L is in cell N44, then subtract =
number in L44 from number in M44. Otherwise subtract M44 from L44.
If have 2 main questions...First, how to get the result of the function =
to show. Right now I see the function typed out in...Vista Word Loading Problem
Have had this Gateway POS for 2 years. Programs all pre-loaded,(no disks)
including Windows Office Suite. Lately, after clicking on the Word icon,
small screen says preparing to install and an install progress bar begins,
then stops about halfway. Notice says "SKUO11.CAB could not be found". If I
cancel the install, I get another message saying, Please run Set Up and
select "repair" (can't find Set Up, Where to look?) If I hit cancel again,
the program begins and works fine. The problem seems to be getting to the
program. Any Ideas?
...Queue info slow to load
We're using two front-end gateway servers that route email to and from the
Internet, and also to internal routing and admin groups (a "hub and spoke"
topology). They're more or less identical and are setup to load balance
email traffic. Both are Ex2k3 on Win2k3 with all the latest service packs
and updates. The back-end environment is Ex2k/Ex2k3 mixed mode.
When i look at the queues for either front-end server by going through their
local Exchange Administrator, one server takes a loooong time to load (a
minute or more), while the other one loads the same informatio...Calling Forms
Usually when i write a Visual C++ program i use Dialogs insted of Forms. When
i want to call a dialog i use the Dialog.DoModal(), but how can i call a
Ricardo Furtado wrote:
> Usually when i write a Visual C++ program i use Dialogs insted of Forms. When
> i want to call a dialog i use the Dialog.DoModal(), but how can i call a
If you have a document/view app, what is usually done is to switch the
view from one formview to another, within the same frame window. Sample
code is shown at:
...Outlook 2003 & msvcr71.dll crash
Recently I've been getting crashes from MIcrosoft Outlook 2003 when I close
it down. Outlook works fine when it's open, it runs properly, but the
moment I goto shut it down, I get an error asking me to submit the data to
microsoft.. When I click the link to see the conents of the error/crash I
get the following:
I have not installed any software around the time that this crash started
happening. In fact my syste...How to use more than 7 IF functions in a formula?
I tried to post a question earlier but it never appeared on the messag
list. Not sure if it went through. So here it is again.
I am trying to set up a formula where when I type in a weight i
another column it will automatically puts in an assigned value for tha
weight. The problem is that the weights range from 110 through 260.
have found that I cannot put in more than 7 IF functions in a formula.
This is my first time trying to do something like this and I am havin
problems. I know there has to be a way to do this.
For example I tried this formula and it worked except I con only put ...