Functions
in [Excel]
|
Multiple IF's with an OR Cell DQ contains a formula that pulls in the status of the item. Here is my existing formula so far: =IF(O2<=N2,IF(DQ2="Text1",IF(L2>0,"Yes","No"),""),"") What I need is for the formula to be edited os that if DQ2=Text1 OR Text2 but I don't know how to do that in Excel 2003. Thanks. ... 4 Jun 2010 13:41
Counting question In column A I have set of characters that are entered into the rows below (i.e. Y, N, MRO) in column B I have another set of characters that are entered into the rows below (i.e. A, E, on so on). I want to count the instances when the rows in Column A contain a Y and the rows in column B contain an A. Is ther... 4 Jun 2010 13:41
How to tell COUNTIF to not count a few characters Im working on a colum that is a medical schedule for Doctor who will be working that day so that I know how many exam rooms will be needed - right now Im working with: =COUNTIF(F14:F43,"*") which tells me how many cells are not blank. But I would like to have countif not count cells in that same colum who have ... 4 Jun 2010 12:34
Workbook causes calculation errors I've never seen this error before, and unfortunately, my Google searches keep bogging me down with the simple "Automatic/Manual" solution... I have Workbook A, which contains a large amount of data/formulas (3000 rows x 100 columns, several columns using SUMPRODUCT checks). The workbook is in Shared mode, and ... 4 Jun 2010 14:47
more details please Hi Roy, what data is in Beezidtable[final] and beezidtable[time]? Is your PC's clock correct? rwtrader wrote: Troubleshoot 04-Jun-10 Can someone help me with the following statement: =AVERAGEIFS(BeezidTable[final],BeezidTable[time],">TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))") It returns DIV/0, but it... 4 Jun 2010 11:28
Count number of instances Need a formaula to look at an entire column and count the number of different times (say date of product) Thanks -- ce ... 4 Jun 2010 11:28
Troubleshoot Can someone help me with the following statement: =AVERAGEIFS(BeezidTable[final],BeezidTable[time],">TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))") It returns DIV/0, but it should return a proper average. Thanks, Roy ... 4 Jun 2010 11:28
How to make a conditional Median function? Looks like this link is no longer valid... "bplumhoff(a)gmail.com" wrote: Hello, Look here: http://www.bettersolutions.com/excel/EAN212/YN616805002.htm HTH, Bernd ... 4 Jun 2010 11:28
AVERAGEIF Condition What is the syntax for AverageIfs? I don't see that function in 2007. "Jackpot" wrote: Try AverageIfs() "rwtrader" wrote: I am having trouble adding an AND statement to the condition portion of the AVERAGEIF statement. Is there a trick to doing this? ... 4 Jun 2010 10:21 |