Return Blank Cel Instead of the word FALSE

**islandeeya** · 01-25-2019, 07:43 PM

Hello,

I need a blank cell instead of a "FALSE". here's my formula:

=IF(A1>=7/31/8,IF(B1="y",A1)," ") (basically, if the date in A1 is equal or greater than 7/31/08, and if B1 is "yes" then enter info from from A1) (A is a date if that matters)
Thank you...

**Glenn Kennedy** · 01-25-2019, 08:38 PM

Excel is not recognising as a date. it is dividing 7 by 31 and then by 8. Here is one way to fix it:

=IF(A1>=DATE(2008,7,31),IF(B1="y",A1)," ")

**islandeeya** · 01-25-2019, 09:16 PM

Thank you, that worked for the cells that have a formula in them, but not the cells that are blank. my actual formula is:

=IF(C6>=DATE(2008,7,31),IF(D284="y",MONTH(d284),"")) (the answer is going in E6)

**Glenn Kennedy** · 01-25-2019, 09:50 PM

IF(D284="y",MONTH(d284)
... if D284 =Y, then return the month of D284??? That does not make sense.

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

**theclockmaker** · 01-25-2019, 10:41 PM

Let's just stick to the same row, part of the confusion is you introduced D284 when we are on row 6. This code shows you what you are asking for:

=IF(AND(C6>=DATE(2008,7,31),B6="y"),A6,"")

B6 can be upper or lower case letter Y, either will work fine with the code above.

If you are unsure of the data quality, (e.g. "Y", "Yes", and leading or trailing spaces) you can use this type of code:

=IF(AND(C6>=DATE(2008,7,31),LEFT(TRIM(B6),1)="y"),A6,"")

I think this answers your question.

**islandeeya** · 01-28-2019, 11:40 AM

I apologize for the confusion in cell number typo. your example worked and removed the "FLASE", but I also need my date to show in the numbered month form. (I've attached a sample...)

**Glenn Kennedy** · 01-28-2019, 08:43 PM

Change e4 to date format and copy the formula down the rest of the way.....

**islandeeya** · 02-05-2019, 05:49 PM

That worked, Than you!

**islandeeya** · 02-05-2019, 05:47 PM

Thank you!

Return Blank Cel Instead of the word FALSE

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Return Blank Cel Instead of the word FALSE

Re: Return Blank Cel Instead of the word FALSE

Re: Return Blank Cel Instead of the word FALSE

Re: Return Blank Cel Instead of the word FALSE

Re: Return Blank Cel Instead of the word FALSE

Re: Return Blank Cel Instead of the word FALSE

Re: Return Blank Cel Instead of the word FALSE

Re: Return Blank Cel Instead of the word FALSE

Re: Return Blank Cel Instead of the word FALSE

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Return False for blank cells with formulas

Return Blank Cell if value is false

[SOLVED] Nested IF return eitheri H, A or blank instead of False

[SOLVED] return the word false

Conditional Formatting / FALSE return to BLANK

[SOLVED] Return Blank instead of False

Excel 2007 : Return True or False if any word in a list is in a string

Bookmarks

Bookmarks

Posting Permissions