isblank

I’m looking to calculate a cell two different ways depending on whether or not it’s blank. For example: if cell B1 is blank, I want to calculate “Today()-A1”. If it is not blank, I want to calculate “B1-A1”. How would I put that into a formula that works? I can’t make it work in an IF Statement.

Hello, I am hoping someone can help me with this formula, I can find a lot of info on the internet but not exactly what i'm looking for. Seems like only part of the formula works but not all of it. Thanks for any help. I'm trying to put a formula for this in cell F2 If E2 is Blank and B2=2 then...

I have 3 sheets with listed different models there you can indicated how many you need of which model (~300 models). I need to use a formula in another sheet that check these sheets and if cell is not blank (quantity indicated), return information to main sheet (order sheet) - name, barcode and...

IF(isblank(D12),(F17<365,F27,IF(F17>364,F37,f12))) Can anyone tell me what is wrong with my formula?

Hi I am reading an article about deleting blank cells. The author suggested to use filter-->blank (see below please). So I tried it on a column which has some blank cells and it did work. Then I did undo that and went to Go Special-->Blank, to highlight them, but excel did not highlight them...

Good morning, I have the following formula that works well for the 1st part of my requirement but need help to meet the second part of the requirement as well. =IF(ISBLANK([@[First TAG meeting]]),0, TODAY()-[@[First TAGmeeting]]) work well but once a project is complete and there is a date in...

Trying to add ISBLANK to the below formula. Struggling to get it to work. Granted, this is for sharepoint but to my knowledge this formula is the same on both applications. I am struggling to add ISBLANK to this so it returns blanks when Date Requested is blank. IF(AND(WEEKDAY([Date...

<tbody> XX XY XZ AA BB CC (Formula) (Formula) (Formula) </tbody> What i am trying to do is if 2/3 are Blank between XX, XY and XZ then give error. But if all are blank or all have a value in it then do nothing

I can not seem to get my function to jive. I want it to populate TBD if an error occurs or if the field next to it is blank. I also have 2 DATEDIF incorporated. I have tried writing it forward and backward.

As the title says I'm wanting conditional formatting to be in use. Column K:K contains cells that are to be manually changed from blank to not-blank. When the cell is not blank I want to cell beside it, in Column L:L, to change text from "Due" to "Complete". Is this possible? I've managed to...

Hi everyone, okay I'm stumped and I'm getting lost in "IF" statements. I feel like I'm making things so complicated. Let me try and explain. This excel file lists units in an apartment building. I need to indicate if the unit is VACANT or AVAILABLE. <tbody> A B C D E F 1 Today's date...

I have found something rather annoying with excel. Running index match to file in a table. Then the table populates lots of formulas. At the moment it has statements like: IF(ISBLANK(B93),0 etc. but I need to expand its ability to account for every form of blank/0/"". I need to do a find and...

It feels that my formula should not be too complicated but I just can't get it to work. Teaching myself Excel here, yipes! If CW16:EA16 is blank and CW7:EA7 is "Sunday", I need it to sum the amounts in CW17:EA17. Otherwise it should just say "0". The following part is good but I need it to...

Without using a macro, does Excel have a better way to do the following: =IF(LEN($A2)>0, IF(ISBLANK(INDEX('092016'!$P:$P, MATCH($A2, '092016'!$A:$A,0))), "", INDEX('092016'!$P:$P, MATCH($A2, '092016'!$A:$A,0))),"") In SQL, for instance there is an ISNULL that only translates the value if it is...

Hi guys, First time poster looking for some help with a formula i am writing. I am writing a formula that take date away from another to calculate the rest period between shifts Here is where I am right now...

Hi All. I have a cell where I have used both ws functions and VBA functions to test content. The cell appears to have no content, but still it is not empty. VBA: isemtpty(cell) returns false WS: isblank(cell) = FALSE code(cell) = #VALUE! istext(cell) = TRUE I'm in doubt about how to...

=IF(J22="","",IF(G9="","",IF(D10="","",IF(AND(J22<>G9,G9=D10),"Closing Disclosure Interest Rate does not match Note or ELC Interest Rate",IF(AND(D10<>J22,J22=G9),"ELC interest Rate does not match Closing Disclosure or Note Interest Rate",IF(AND(D10=J22,G9<>D10),"Note Interest Rate does not match...

I am using the following syntax to find a possible date or blank: =INDEX(Invoices!$B$2:$B$192,MATCH(E2,Invoices!$A$2:$A$192,0)) Since the column were the result is displayed should be in date format, empty finds are displayed as 1/0/1900. I know that I can use the test: IF (result = blank...

Hi all! I am trying to return one number if an cell is greater than an amount and another if it is less than and generate nothing if the cell is blank. I have tried several manipulations of this and I just cant seem to get it right. Here are the stats If E2 is blank return " " If E2 <=9000...

Hi all I am having difficulty to find the correct formula for my excel report. I want to calculate the number of NETWORKDAYS from either; the start date of my process (AJ5) to the completion date (AR5) or the start date of my process (AJ5) to TODAY's date (for work in process lead time) I am...