i need to write an IF function that displays "made" if the average in H5 is less than 76 and "cut" if the score is not less than 76. help?!! =if(h5<76,"made","cut") maxwell wrote: > > i need to write an IF function that displays "made" if the average in H5 is > less than 76 and "cut" if the score is not less than 76. help?!! -- Dave Peterson ...

Can you put macros into formulas to run automatically if special criteria is met? Hi Ben! Formulas only return values to a cell. But you can use a Worksheet_change event handling macro that will run based upon the results of a target cell. A Google search on Worksheet_change should produce lots of examples that might be tailored to your requirements. Or you could post more details of what you intend. -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Ben&...

Is there a way in which I can use a function or formula to add, multipl and/or divide cells which are formatted differently and get an en result? I am specifically needing to divide a general number by tim frames (hh:mm:ss) and multiplying by another general number, yet I hav no idea if that can be done. Help -- rcdunn200 ----------------------------------------------------------------------- rcdunn2003's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=138 View this thread: http://www.excelforum.com/showthread.php?threadid=26894 Hi as a starting point: http://ww...

Hi, I want to use formula in condition syntax, but I don't know how to reference the value being tested. Like: SUMIF(A1:A10;">10 AND <20") Or: AVERAGEIF(A1:A10;"ISODD(...)") Thanks for any ideas. Jan For your <<< SUMIF(A1:A10;">10 AND <20") >>> Try: =Sumif(A1:A10,">10")-Sumif(A1:A10,">=20) OR =SUMPRODUCT((A1:A10>10)*(A1:A10<20)*A1:A10) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGro...

I am new to Excel formulas. I assume i need an IF statement but not sure on correct syntax =D2-B2 is what i have now, what can i add to it so that it only displays values >0? Hi =IF(D2-B2>0,D2-B2,"") "superfooz74" wrote: > I am new to Excel formulas. I assume i need an IF statement but not sure on > correct syntax > =D2-B2 is what i have now, what can i add to it so that it only displays > values >0? =if(d2-b2>0,d2-b2,"") "superfooz74" <superfooz74@discussions.microsoft.com> wrote in message news:C57B3ED5-1197-4056...

I have a cell(C27) with the foumula: =TODAY()+1 When I open the file on Friday, it shows Saturday. I want it to show Monday. How do I modify the formula if C21 is Saturday(6), then Weekday +2 My formula that doesn't work is: =IF(TODAY()+1=WEEKDAY(6),TODAY()+3) Am I close??? Joe One way: =IF(WEEKDAY(TODAY())>5,TODAY()-WEEKDAY(TODAY(),3)+7,TODAY()+1) another, if you have the Analysis Toolpak Add-in loaded (Tools/Addins..): =WORKDAY(TODAY(),1) In article <uqXKY5g2EHA.3128@TK2MSFTNGP14.phx.gbl>, "lunker55" <this_is_not_my_email_address@hotmail.com> w...

I raised a WM_LBUTTONDOWN AND WM_MOUSEWHEEL at the same position of a window, but found that the CPoint pt in the OnMouseWheel is different from the CPoint point. I tried many times, the CPoint point is alway the same at a certain position but the CPoint pt varies in a range of 100, why are these two coordinates different? And how can I transform them? "wang" <wang_jia_ji@21cn.com> wrote in message news:087701c38559$d97828a0$a301280a@phx.gbl... > I raised a WM_LBUTTONDOWN AND WM_MOUSEWHEEL at the same > position of a window, but found that the CPoint pt in the >...

I know I can Google this, and have, but am up against a deadline, and I'm not sure how to "convert" text dates such that they can be used with DateDiff. I have two dates, output by a batch file, in the format: Time1 = "Fri 01/22/2010 16:18:17.37" Time2 = "Sun 01/24/2010 04:32:11.33" I want to calculate the difference between these, with something like: TimeElapsed = DateDiff("h", Time1, Time2) and I need the time thrown in there, not just considering dates. I think I have to convert Time1 and Time2 to some other type of value first...

SPS looks like ColA ColB ColC ColD ColE ColF N N N N N N N N N Y Y N N N N I need to create a new column that says if there is only N's OR blanks in any row from Col A-F, put a Y, so in the example above ColG would have a Y in rows 1 and 4. Is this doable with IF/OR/AND? Thanks Lynn Hi, Lynn- You could count the Ns and blanks; the opposite way to think of that same scenario is the absence of Ys. If you like that logic, yo...

I was given a project to scan all of the Excel files on our network and generate a report listing the files and wether they use Macros. I was thinking of using VB6 to scann all dirs/subdirs...easy part. Question: -- How do I quickly scan an excel file and determine if it has/uses Macros using VB6. I appreciate you taking the time to read this and any help anybody can provide. Thanks. I was on a project to do something similar, and besides an automated chaeck, there was a need to have each Excel file with potential code/upgrade issues checked. I believe there is a HasMacro bit you can ...

Hello, I am using a manifest file to emulate the windows xp style, but I am having a problem with edit box controls that I create dynamically - I am trying to give them the same look as edit box controls manually put on the dialog, but the dynamic edit boxes look incorrect. Here is what I am doing to create the edit box: bRetVal = pEdit->CreateEx( WS_EX_CLIENTEDGE, "EDIT", "", WS_CHILD | WS_VISIBLE | WS_TABSTOP | WS_BORDER | ES_AUTOHSCROLL, rect, this, m_iControlID); How can I get the vi...

If the number in B1 is greater than the number in A1 and the word to appear is INVERTED then =IF(B1>A1,"INVERT","NORMAL") works in C1. How can I format cell C1 so that it is red for INVERT. Take a look at Format|conditional formatting. You can change the format based on the value in the cell. Old Red One wrote: > > If the number in B1 is greater than the number in A1 and the word to appear > is INVERTED then =IF(B1>A1,"INVERT","NORMAL") works in C1. How can I format > cell C1 so that it is red for INVERT. -- Dave Peterson ...

Hello. I am new to this group and will try to explain two problems. Hope you understand my poor english. My questions are probably easy for most of you, so I hope someone will help :-) Problem one. I am making a spreadsheet where I have to use names not cell numbers (can not use B1, C3 and so on). I shall use the f(X)=ax3 + bx2 + cx + d formula (the number 3 and 2 are exponents -if that is what is it called). I am going to write a start value (lets name the cell Start), a step value (Step) and a,b,c and d. The last four cells are named a, b, c_ and d. All this is quite all right but i a...

I have a form field dropdown box that has two options. I need to put an If statement after it that should read something like "If Box=Applies "more text" else blank." So the following text will either appear or remain blank. I can't figure out how to reference a field form entry in the If function or if this is even possible. Please help. Hi That70sHeidi, Your IF field's construction should be: {IF{REF Dropdown1}= "Applies" "Additional text"} To get the correct 'name' to use for 'Dropdown1', right-click on the for...

I am trying to workout numerology in excel: I have number 1-9 in row - 1 Alphabets A-I in row - 2 Alphabets J-R in row - 3 Alphabets S-Z in row - 4 I wish to know if I input a value from "A-Z" in different cells, I should get corresponding numeric values say A20=S,B20=A,C20=I in three different cells should return A21=1,B21=1,C21=9 Can somebody help me resolve this? Thanks, =MOD(CODE(A20)-65,9)+1 Or, if the numbers in row 1 might change: =INDEX($A$1:$A$20,MOD(CODE(A$20)-65,9)+1) "Sai" <Sai@discussions.microsoft.com> wrote in message...

i am having trouble with getting the statement to work like i need: IIf([REFUND_LETTERS_ALL_COUNT].Counter=1,"First Request","Second Request ") AS Expr1 What I need to do is nest this statement so that the result will show Counter = 0, blank Counter= 1, “First Request” Counter = 2, “Second Request” Etc…. As of now, it returns "Second Request for all records. On Fri, 21 Mar 2008 10:09:01 -0700, ACSer wrote: > i am having trouble with getting the statement to work like i need: > > IIf([REFUND_LETTERS_ALL_COUNT].Counter=1,"First Request",&qu...

=IF(ISERROR('Tank Sizes'!$F$30-('Tank Sizes'!$F$30/B3))/3.79,"",('Tank Sizes'!$F$30-('Tank Sizes'!$F$30/B3))/3.79) How do I add =If(B3<D3,"" to this formula I don't want the results to show up if it's a negative number. Thanks in Advance! As well as adding that snippet plus a comma to the beginning, you will also have to add a closing bracket to the end, like this: =3DIF(B3<D3,"",IF(ISERROR('Tank Sizes'!$F$30-('Tank Sizes'!$F$30/B3))/ 3.79,"",('Tank Sizes'!$F$30-('Tank Sizes'...

Hi I�d be really grateful if someone could assist me in how to �formula the below: I have twelve identically formatted worksheets (�A� through to �J�) In each of the cells B6:F6, B10:F10, B14:F14, B18:F18 & B22:F22 on eac sheet there will be a different one of 5 words (each word can and wil occur more than once within the above range). For the purpose of thi exercise I need to ignore the text in the other rows (eg 7-9, 11-1 etc). What I need to tally on a separate sheet within the workbook is ho many times each of the five words occur in the group above (eg B6:F6 B10:F10, B14:F14, B...

I have a dollar amount in cell F23, say, with a formula in G23 to deduct that from subtotal in G22. The formula in G23 looks like this: =IF($F23<>"",($G22-$F23),"") This works great. But I've run into a problem I need to adjust for and can't figure out. These columns, F and G, from rows 18 to 31 are for miscellaneous information. Sometimes I have amounts to deduct, other times it's just info in the description column B to the left of F (there are some merged cells there) about payments in the rest of the spreadsheet and no amount needs go into column 2...

I am trying to simplify a pricing spreadsheet that I use at work. I a using the following criteria; the $ value of a product, the descriptio of a product that I have on a cost page. What I want to do is when type in the description of product X in a specific cell, I want the value of that product returned to another specific cell. Example: Lexan14SS (in a cell); 1.75 ($ value in another cell). On a pricing spreadsheet I type in Lexan14SS and I want that specific value returned to another cell. Of course though i will have mutipl product descriptions and prices to go along with those produc...

Right now I have Open "LPT1:" For Output As #1 But I can't use my LPT1 printer at the moment. Is there a way I can specify a networked printer? Ed Not sure what this has to do with Excel spread sheets, but you can do "NET USE LPT2 \\computername\sharedprinter\" and then you should be able to "Open "LPT2:............... Ed wrote: > Right now I have > Open "LPT1:" For Output As #1 > But I can't use my LPT1 printer at the moment. Is there a way I can > specify a networked printer? > > Ed > On May 3, 7:42 am, Bo...

I have a list of data in cells d11:d15. I want to be able to count how many of the data points fall within a certain numeric range (ie less than 100 but greater than 50) but I want to be able to reference a specific cell containing the criteria rather than using '100' or '50' in the formula. In my worksheet 50 is in cell I2 and 100 is in cell K2. Try this: =COUNTIF(D11:D15,"<"&K2)-COUNTIF(D11:D15,"<="&I2) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Kim B." <KimB@dis...

I need to subtract 4 days if Tuesday, 3 days if Monday, 2 days if Sunday and 1 day if Saturday. I would like to include this with the formula I'm using now. (E2-7) the cel the formula is in and the cell i'm subtracting from are both formated as dates (11/18/09). Can anyone point me in the right direction? Thank you, Hi, =E2-CHOOSE(WEEKDAY(E2,2),3,4,0,0,0,1,0) Mike "Buschwack" wrote: > I need to subtract 4 days if Tuesday, 3 days if Monday, 2 days if Sunday and > 1 day if Saturday. I would like to include this with the formula I'm using ...

Hi all, I'm trying to set up a message that will generate from an IF formula. At the moment I'm at: =IF(E3="*C3","","Please check that you have chosen") The content of C3 is a part of the content in E3 e.g. E3=161426 oxygen and C3=oxygen. I want to check that what is in C3 is also in E3 and, if not, put up a message. All help appreciated. Try it like this: =IF(COUNTIF(E3,"*"&C3),"","Please check that you have chosen") -- Biff Microsoft Excel MVP "DamienO" <DamienO@discussions.microsoft.com> wr...

In a spreadsheet I have columns that perform different parts of a calculation, these are all brought together in one final formula. However, it is possible for one column to return negative values - but I want to ignore these and only use any positive values that are returned. IF 'T2'<0 seems to make sense as a beginning, where T2 is the first cell containing a value. But where do I go from there, what makes a viable ending? TIA Dave Dave The IF function has three parts, seperated by commas... =IF(Comparison, What to do if true, what to do if false) Your formula might look li...