logical

I have a program for a charitable gaming calculator but don't understand exactly what the formulas do. There are six entries per 'race'. The formula is: IF(TRUNC((total bets all 6 entries/2)/bets on this one entry)=1,2,TRUNC((total bets all six entries/2)/bets on this one entry)) I...

I have a fluctuating data in column A:A, a Fast MA in column B:B, Slow MA in C:C. I'm going to start with the first formula to compute in Column E:E, which 1. needs to display a prior value repeated at least 3 times consecutively (not in order of occurrence just needs to be in the formula...

I have a VBA conditional function I hacked together (I'm a noob) that does a hex 'AND" function on a 36-bit value in a cell with another 36-bit value. This result is then passed though another function (total hack) that looks for logical '0' other wise it assumes logic '1'. The second part is...

<tbody> F G 6 0 7 0 8 460 9 460 10 -40 11 -70 12 -70 13 -70 14 -70 =IF(ISNA(MATCH($B$1;F6:F13;0));0;1)) </tbody> Dear forum, I am trying to create formula when in the range F6:F13 there is number that is less than or equal to 0, then formula will get 0, and if there...

hello, i want to write a logical function assuming in C2, for lets say if another cell in column A (i have about five thousands rows) is same as A2 and the cell in B column belonging to same row as that one is not blank, then c2 shows "full" otherwise "blank" would very much appreciate any...

I have a worksheet with two Sheets: 1 sheet for my report, and another with my Sales database. The database has brand names of products in column A and number of units sold in column B. I need to sum items by category by adding up all the sales of each brand name. My Units Sold Formula on my...

Hi Everyone, Here is my challenge. It may sound easy but I have not been able to find a solution as of yet. I am creating a template so that when I upload data it auto populates and I have little work to do. Here is my problem: I have a list of Sales and wish to rank them (easy...

Hello, I have a formula which goes something like this =IF(D7="Yes/No?","Select Yes or No on Instruction sheet", IF((D7="Yes")...

I am creating a template for a report based tool. I have different return in column A (in the sense that Toronto or Houston, etc may come in different amounts based on my data). I need a formula that I can drag down 200 rows and will not have to worry about my output into column D. Please...

I need to create a formula whereby if cell 'A1' = 123456, then cell 'B1' automatically changes to a description. i.e. a prodcut description. This I have done using =IF(A23=Sheet1!B2,Sheet1!A2,). However, this only seem to work when referencing one cell. I need to be able to reference many cells...

What is wrong with this formula?..I am getting the 'the formula you typed contains an error"...grrrr.. =and(now()<f4 ,b4<1) f4 is a date field = 6/30/09, and b4 is a number field containing .71...