isblank

I have a workbook with several tabs. In the front sheet (sheet 1) I want to add up the total of cell A5 from every tab. Every tab pulls data from the master sheet (Master sheet) using the below formula. =IF(ISBLANK('Master sheet'!AA5),"",'Master sheet'!AA5) This is causing the problem as...

Hi, I am a teacher and am trying to make a spreadsheet where one sheet displays grade values (letters) and the second sheet displays the numerical value of the corresponding cell (UK AS levels - A=60, B=50 etc.). I have used VLOOKUP to do this, however as each student only studies a particular...

Is there anyway to reduce this formula into a simpler form? =IF(AND(ISBLANK(C11),ISBLANK(E11)),"",G10+SUM(C11,E11)) For instance, any way to combine =IF(AND(ISBLANK(C11),ISBLANK(E11)) this part of it?

I have this in H13 <tbody> =IF(G13>TIME(14,0,0),"✘", "✔") When there is no info in G13, I want H13 to blank. How do I do this. I've fiddled with ISBLANK, but nothing seems to work. Thanks for the help! </tbody>

Hi Everyone, So I'm trying to create an IF function that will make a cell blank if another cell is blank. I've tried using =IF(ISBLANK(A1),"",A2), but even though A1 is 'blank' A2 is still returned. I believe this is because in A1 there's another IF function, =IF(A3>0,"",A4), which puts "" in...

Hi I have drawn up a draft table of the spreadsheet I am currently working on. The formula in D3 works perfectly fine, it gives me a value of the number of days taken to resolve the incident. However, until the incident is open and there is no date in Cell B3 I need to check how long has the...

Hi All, I have built a spreadsheet which will hopefully show MEDIAN and MEAN based on selections in dropboxes. I want my formulas to ignore the references in the dropboxes if they are blank. I know I will probably need to use ISBLANK but I am not sure where to put them. My mean formula is...

The title of this post is confusing as heck, so I apologize for that in advance! I know there's a way to do what I'm looking for (there's always a way), but I'm having a hard time with it this morning. I'm hoping you guys can help! I'm looking to create a formula that will show, in the cell I...

I am using the if formula in in addition to the isblank formula to have Excel pull serial numbers/locations from a database list. I currently have it set that one column requires me to enter in say the location and then the second column uses the if formula to initiate the MATCH formula to pull...

Dear Excel community, Can someone please explain the below formula. What values are the condition using. Many Thanks in advance. =IF(ISBLANK(G32),F32,F32*E32+G32*(1-E32))

Hi, I am trying to apply the conditional formatting to a column D in a spreadsheet. I need the following: If there is a value in a cell A1-the cell D1 needs to be filled with yellow, if there is a value in a cell B1- cell D1 becomes red, if the value in cell C1=100%, D1 becomes green. I used...

The criterias for the formula I need goes something like this. If M < 40 then "Not required for PIC", If T = "Not applicable" then "Not required for PIC", It T < today's date then "Overdue", If todays date < T and greater than Y (If there is no date in Y column then formula should take date...

Thisis the code that I was using. Note:ISBLANK. IF(ISBLANK(R121"",IF(U121=0,"",MOD(R121-I121,1))) I changed it toIF(R121<>"",IF(U121=0,"",MOD(R121-I121,1))) And now I get"FALSE" in cells that are not used yet. Please note, ifthere is no 'Reading', then the row is blank. But if there is...

Hi, I want to write an IF formula that checks if two IsBlank(X) are both "TRUE", E.g. <tbody> Some Text Some Text Formula Result = FALSE Formula Result = TRUE Some Text Formula Result = FALSE </tbody> I have found a workaround but would love to know the correct way to do this...

Hi there, I have a spreadsheet to track inventory locations. <tbody> C D E F 1 Bags From To Balance 2 40 3 20 Quincy OL 40 4 5 OL 35 5 10 Quincy 45 6 </tbody> If there is no entry in Bags (C6), leave Balance (F6) blank. Row 2 is just to show the beginning...

I am using the sheetoffset formula that has been written about previously on this site. I would like to input the value for a cell from the sheet next to it if it has been left blank on the original sheet. Here is the code for the sheetoffset function: Function SHEETOFFSET(offset, Ref) '...

I am having an issue with a similar request. I need to send my excel sheet to the user with blank cells to be filled in. Once the user opens this book I need to prevent the user from being able to save the workbook without the specified cells filled in. (This portion I have code that works for...

Hi Folks, Excuse my stupidity, I have a fairly straightforward excel formula question. I am trying to use the following formula: =IF(ISBLANK('Contract Compliance Month 3'!F38:F39),COUNTA('Data Sheet'!D7:D64)) if a certain cell, F38:F39 is filled, run the counta formula and display the total...

I have a query relating to conditional highlighting - specifically highlighting a cell's column and row based upon whether it contains data or not i.e. if it is blank, it's column and row remain unhighlighted, but when it contains data, it's column and row should become highlighted. I could...

Hi - I am trying to create a condition in a SUMIFS function that looks at works as follows: A B C D (Date) (estimated) (actual) (quantity) 1 9/1/13 9/1/13...