How do use the if formula
How do I use an IF formula that displays PASSING if the average of the
project grades is at or above 36 points and UNSATISFACTORY if that is not the
if each score is in cells A1 to A4 then use =IF(AVERAGE(A1:A4)>=36,"PASSING
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get
Ice Hockey rules (especially the Wightlink Raiders)
> How do I use an IF formula that displays PASSING if the average of the
> project grades is at or above 36 points and UNSATIS...Need to reference a block of cells from another sheet.
apologies if this is probably a mundane question, but I didn't know what
'search terms' to put in google to return any results..
I've got a Spreadsheet with 12 tabs (sheets), I need part of tab 12 (sheet)
to appear on tabs 1-11 (sheets), so that if I change data in tab 12 (sheet),
tabs 1-11 (sheets) are changed too.. the cells themselves will never move
location, just the data within them..
Is it possible?
On your sheet1 select the cell that should receive the data from Sheet12;
Hold down the Shift key and Click on Sheet11 << this shoul...Creating charts from formula results
Im trying to create a chart in Excel based on the reult of a column or
formula's I wrote. The chart just seems to show the formula as its
values, can anyone help?
I had a list of employee ages and used a formula to indicate their age
bracket (e.g. 16-24, 25-30, 31-40 etc). I now want a bar chart that
will show how many employee's are in each bracket.
Help is much appreciated asap as its for my job. Thanks in advance.
Boba Fett's Profile: http://www.excelforum.com/member.php?action=getinfo...Copying formulas
Is there an easy way to copy this to about 700 cells?
there has to be an easier way to copy this.
Easier than what? Copy and paste? Or drag to fill?
If you want exactly the same in all 700 cells, make the cell references in
the formula absolute & it will copy without change. [But why would you want
to do that?]
If you want any or all of the references to change as the rows or copies
change, make the relevant parts relative addresses.
"tim2216" <email@example.com> wrote in message
new...Cell Value as Named Range Reference
Little bit of a quirky question...
Trying to use a cell value as a reference in a formula, where that
cell value is the name of a named range.
So, assume A1:A3 is a named range: Rng1. And, B1:B3 is Rng2.
I want to get the correlation vale for A1:A3 and B1:B3
So, cell D1 contains "Rng1" and D2 has "Rng2"; and cell D3 has the
formula: =correl(D1,D2). But I get an error. Have also tried using
Indirect to no avail.
Any help would be hugely appreciated. Thank you.
http://www.wimgielis.be = Excel/VBA, soccer and music
"ste...copy formula #3
I just upgraded to office 2003. When I get a lower
version file from someone, and I do a copy and paste, it
copies the exact same formula with the $ sign which I
cannot see where to get rid of.
The calculation box is set to automatic, not manual. How
do I resolve this? I didn't have that problem before.
this has nothing to do with the Excel version. In this
case the formulas was entered with absolute references
(the $ signs). If you want the references to change you
have to delete these $ signs. Either manually or clicking
on the reference and hitting F4 to toggl...refering to a name range area as a reference value multiple times on a worksheet at different locations
i was wondering if i had posted this in the right section as it could
apply to both
please could you take a look at the following post
Is there some reason you can't post your question here instead of asking us
to look elsewhere?
Microsoft MVP Excel
"Blinds Nottingham" <firstname.lastname@example.org> wrote in
Column A Column B Column C
25 50 No
30 30 Match
26 28 No
I am using the above formula to compare two columns (A and B) for
overlapping (common) data then put the result ("Match" OR "No Match") in a
So far this formula has work...What is IVA# in Distribution Reference and Reference?
We did an inventory adjustment and now we get a unknown amount in Debit under
the Inventory account and Credit for COGS account in the Transaction Entry
Zoom. We're trying to figure out where that amount came from but we couldn't
zoom more than what it's currently shown. In both fields, Reference and
Distribution Reference, it's shown IVA#######... that is unknown to or setup
by us in anywhere, i.e. Audit Trail, Source Document.
Does this amount affect the dollar in the accounts mentioned?
And can anyone please help to where we could drill down the IVA details?...Formula to calculate Latest Cost (inventory valuation)
I have a worksheet that contains the daily purchases for 4 products.
column B contains the products
column D contains the purchase price
column K contains the division
column J contains the day of the month
I need a formula that will pull the latest purchase price by product by
division. In other words the last purchase for the month and the associated
You can do that with this array* formula:
"Curtis" <email@example.com.(do not spam)> wrote in message
news:61160B81-7277-4C97-8...how do i enter data for a # of years using a formula?
i am working on excel and the book asks that i enter data s=using formulas
for specifically the last three years of what i am referencing to. and i have
to know how to us the copy command button. can anyone help
...Need a formula...
I have been given a task to collect info and create several spreadsheets
but I have one more formula to create. Here is it...
The formula has to callers receiving points for the amount of Western
Union sales they have for the month. Let say the entire department
AVERAGE (this number will change every month) was 161 sales; then 161
would be the median.
If the caller had 171 - 180 sales then he or she gets +1 point.
If the caller had 181 - 190 sales the caller gets 2 points, etc..
until the mark of 321-330 in which they get 16 points.
So, if I enter the number 255 in the cell then the an...Summing types with one formula
I am having difficulty writing a formula to sum two different types of
data in single formula. I know how to use an "if" statement to create
another two columns and add this way, but I would like to use a
vlookup, maybe?, or something to total. Below is a simplified version
of what I am trying to get two different sums for. I need a total of
"DIV"s and a total of "AP"s as well. Thank you for any assistance.
AP ...macro button refers to prev. workbook?
When I create a macro in Excel, and assign a button to it, it works
fine the first time, but when I re-open the workbook for a second
time, and try to run the macro again, the macro seems to refer to the
previous workbook...For some reason, the macro saves the name of the
Dim name As String
Dim adress As String
name = ActiveSheet.Range("B6").Value
adress = ActiveSheet.Range("B4").Value
ActiveWorkbook.SaveAs Filename:="C:\WINDOWS\Desktop\Temp...Date Formula #2
I am trying to write a formula that works off what is in two separate cells.
It has several parts and maybe not all of them can be done. It would be
great if someone could help me out. Here goes.
If A2 & A3 each have a "N" in it then I want cell A5 to show today's date
plus 20 weeks. However, if only 1 of the cells A2 or A3 has a "N" in I still
want A5 to show today's date plus 20 weeks.
Can this also be done? If both A2 & A3 have "Y" in them then I want A5 to
freeze with the date last show when 1 of the two cells had a "N" it ...Fix Broken Cell Formula with VBA
I have a cell formula that is damaged each time I run a delete to
remove excess rows before a paste & copy. this formula links to a
cell that is always deleted. So I am trying to repair this formula at
the end of each cycle.
Here is the correct formula:
Here is the same formula after the delete:
I tried to fix this in the code that does the finale copy & paste with
Range("B2").Formula = "=IF(A11=...Formula Problem2
I am trying to raise a formula that gives me a sum of two
cells when there is a positive value present and the
following appears to satisfy this.
The problem is that if the cell H55 is actually empty, I
want to sum two different cells in this case H54+H56.
Is there any way of achieving this with the OR or some
I received some very helpful replies to this enquiry 30th
June 2004 but..............
I am getting there :-)
Every one of the suggestions worked but only when I
deleted the content of cell H55. Cell H55 actually ...Column and Row reference
How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top and right hand side references
Uncheck "row and column headers".
Good idea to spend a few minutes browsing through the various Tools>Options
tabs to see what else is available to toggle on/off.
Gord Dibben Excel MVP
On Mon, 19 Jul 2004 15:53:02 -0700, "Dave" <Dave@discussions.microsoft.com>
>How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top an...i need halp with a formula
i am trying to make a formula that says "if text in cell A1 is "apple" then
add number in cell A3 to cell A2"
If Text in cell A1 is Orange then add number in cell A3 to Cell A2
That looks like the same action to me.
Where does the result go? If you want it in A2, you need code.
(remove nothere from the email address if mailing direct)
"detlghtpd" <firstname.lastname@example.org> wrote in message
> i am trying to make a formula that says "if text in cell A1 is "...Formula #10
Formula in C3 is =IF(E3>D3/12,E3,D3/12).
I would like to have the cell (d3 or e3) where the data entered last control
the answer in c3.
Put this in C3 instead.....
Vaya con Dios,
"Val" <Val@discussions.microsoft.com> wrote in message
> Formula in C3 is =IF(E3>D3/12,E3,D3/12).
> I would like to have the cell (d3 or e3) where the data entered last
> the answer in c3.
I had a problem today with a missing reference - Microsoft Forms 2 on a
colleague's machine at work (Office 2003; VBA 6.5; XP).
I've read Chip Pearson's "Missing References in VBA" which is a geat
explanation about how to fix problems like this.
Oddly the library didn't seem to be flagged as "missing" and was in fact
present in the system32 directory but didn't show up in the list of
Now to the questions:
I'm not clear on whether if I write code in a project that references a
library which is not part of the &qu...Reference
Is it possible to create a reference to another object such as:
int & x = i;
but using an image list, and referencing different objects depending on a
such as :
CImageList & imageList;
if (thumbnail == 1) imageList = m_ImageListThumb;
else imageList = m_ImageListFullSize;
Hope this makes sense!
You're better off using pointers for this. I believe, depending on the
class, that what you're trying to will make a copy of the object instead of
"Ben Williamson" <email@example.com> wrote in message
news:43ee4603...zeros in cells with formulas
when I enter a formula in a cell it displays a 0, when there is not an answer to the formula. Is there a way to keep the formula but get rid of the zeros
any help is greatly apperciated!
In Tools>Options>View, uncheck the zero values checkbox - that hides them
Other way is to trap it, like
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Darrell" <firstname.lastname@example.org> wrote in message
news:D4B48DFF-...Question about charatcer in formula
A co worker is taking an Economics class and has an Excel formula tha
calculates raising interest rates. The formula provided is (1+r)^t
is represntative of column A. She is unsure what ^ is suppsed to mea
or do concerning this formula? Any thoughts and answers are greatl
appreciated. Thanks Ja
Message posted from http://www.ExcelForum.com
The ^ (caret) is an arithmetic operator which
stands for "Exponentiation" (to the power of)
Example: 3^2 is the same as 3*3
Please respond, in newsgroup
"Jay Hanks >...Macro to Reference Column Next to Current Reference
I'd like to automate the following procedure using a
macro. Please help.
1) i have 2 sheets: Sheet1 & Sheet2
2) In Sheet1, Cells B2,D2,F2 has the formulas "=Sheet2!
F2", "=Sheet2!K2", "=Sheet2!P2" correspondingly.
3) Every month when i do my work, i'd have to manually
rekey the formulas to reference the subsequent columns,
ie, Cell B2,D2,F2 will change from above to "=Sheet2!
G2", "=Sheet2!L2", "=Sheet2!Q2" and in the following
month, I have to change manually again to "=Sheet2!