blank cells formula

I need a formula that if a cell is empty then it will used info from another cell, but then if I add text to that cell it will show that info util it is deleted and is blank again so it would revert back to the formula. <tbody> A B 1 table 50 2 chairs 300 3 none 0 4 if blank then use...

I have been racking my brain and google for a few days now and cannot figure this out. Column K is sparsely populated and I cannot figure out a formula to copy down the data from the most recently populated cell in that column whenever the adjacent cell in column L is populated. can anyone...

Hi all, I am just trying input a formula to know if a large spread sheet with a certain task has been completed or not. I have 100 cells that all need to be input with a value (e.g. cell is not blank) for it to be deemed to have been completed. The cells are...

<tbody> Help!!! I need a formula for this case: In sheet 1, there are two columns A and B. If a number is inserted in column B, the matching projectno. in column A needs to be transferred to sheet 2. Blank cells has to be skipped so there will be a list of projectno. which will activate if the...

Have 6 columns of data (like below but some columns could be blank or even all) and then a column that will summarize the preceding information such as the examples below: <colgroup><col width="87" span="7" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> AG1 MSC1 MG1 SR1...

Hello I used this formula to help me find a full match by writing down a partial string in an empty cell next to a contact list of the company I'm working for. =IF(ISERROR(...

<tbody> I'm so new it hurts...but I'm trying. I just don't see this problem listed in the forum. What am I missing? A B C F G <tbody> TIME NAME AGENT ROLE/NOTES </tbody> </tbody> <tbody>...

Hi, I have a formula in a cell which i need conditional formatting. The formula is as follows; =IF(ISERROR(AVERAGEIFS($J$17:$J$34,$A$17:$A$34,"Day",$B$17:$B$34,"PF18")),"",(AVERAGEIFS($J$17:$J$34,$A$17:$A$34,"Day",$B$17:$B$34,"PF18"))) My conditional formatting basically states that; >=$H$39...

I'm trying to write code to cut and paste a single selected cell into the first blank cell in a specified range (eg H4:H18) but I've been using (xlUp) which isn't returning the desired effect. I don't think (xlUp) is the solution to my problem, but I'm not sure how else to go about it? Sub...

Hi guys. Got a problem with an If formula. in cell B11 i've got number of hours worked. and then in p11 i've got a formula that i want to return a certain set of data. Something like this. =If(B11=0,"RESET DAY","") this works fine but if the cell is blank then it still returns "RESET DAY"...

I am hoping you all can help me with a conditional formatting problem. I'm using Excel 2007 with Windows 7 Pro SP1 OS. I need to format all the cells in column C, so that if their value is blank AND the value in column G (same row) is equal to the value "child" (without the quotations) the fill...

I want to look at cells AR3, AS3, AT3, and AW3. If all of these are blank, I want to put an "x" in AV3. What's the easiest way to do this? (AR, AS, AT & AW could have text in them.

I was wondering if someone could help me with my code. I'm a very basic vb user and have the following code. I'd like to know if there was a way of cleaning it up a little rather than using IF statements. I've tried using the go to next blank row and loopoing but as it contains formula it just...

Hi guys, I've got this table below whereby row C contains data inputted by a user and there could be duplicate entries, so I've got formulas in Column A and B that remove the duplicate entries, as you can see: Excel WorkbookABCD1EntityAdditional Sheets to...

Hi Chaps, Why is it that when I use the following formula in cell C3...=IF(A1>0.95,"A","") and then in cell A1 i have the formula =IF(ISERROR(B2/B3),"",SUM(B2/B3)) I get the result "A" even though cell A1 results in either a #N/A! #DIV/0! error. Is there any way around this? Cheers

I have this formula (see below) set in columns F and G to convert DateTime (columns B & C) to Month/Day/Year. I applied this formula to the entire column so when columns B & C are empty, the date is still converted to 1/0/1900 all the way to cell 65000+ =MONTH(B3) & "/" & DAY(B3) & "/" &...

Hello gurus, I have an urgent issue. =DAYS360(**IF**;NOW();TRUE) In upper formula I need to replace **IF** with a formula that will use the value in cell J2, or H2 (if there is nothing in J2), or K2 (if there is nothing in J2). Important: If there is value in all cells, the value in J2...

=IF(AND(E7<=1,F7>=1),"pass","fail") I want the above statement to only be performed if C7 and D7 are not blank and do not contain NA In the same statement I want NA as a result if C7 and D7 contian NA or are blank Can anyone help?

Sorry, I'm sure it's been asked before... I am using a time stamp in B2 to clock in, and a time stamp in C2 to clock out, and the following in D2 to calculate elapsed time: (every time I post my formula it gets truncated) =IF(C2<b2,c2+1,c2)-b2><b2,c2+1,c2)-b2"> Here it is with spaces added so...

Say that in every cell (A1 to A10) of a sheet, I select an item with Data Validation / List. The list is a named one (say 'List1'). After each selection I enter data (only numbers) to the adjacent cells (the same row, columns B to D). What I want is when I delete the content of cells B1 to D10...