If cell is blank - Excel formula - Exceljet

The Excel ISBLANK function returns TRUE when a cell is empty, and FALSE when a cell is not empty. For example, if A1 contains "apple", ISBLANK(A1) returns FALSE ... Skiptomaincontent Ifcellisblank Genericformula  =IF(A1="","blank","notblank") Summary  Totestacellandtakesomeactionifthecellisblank(empty),youcanusetheIFfunction.TheformulaincellE5is: =IF(D5="","Open","Closed") Explanation  Thelogicalexpression=""means"isempty".Intheexampleshown,columnDcontainsadateifataskhasbeencompleted.IncolumnE,aformulachecksforblankcellsincolumnD.Ifacellisblank,theresultisastatusof"Open".Ifthecellcontainsvalue(adateinthiscase,butitcouldbeanyvalue)theformulareturns"Closed". Theeffectofshowing"Closed"inlightgrayisaccomplishedwithaconditionalformattingrule. Displaynothingifcellisblank Todisplaynothingifacellisblank,youcanreplacethe"valueiffalse"argumentintheIFfunctionwithanemptystring("")likethis: =IF(D5="","","Closed") AlternativewithISBLANK ExcelcontainsafunctionmadetotestforblankcellscalledISBLANK.TousetheISBLANK,youcanrevisetheformulaasfollows: =IF(ISBLANK(D5),"Open","Closed") Author  DaveBruns Relatedformulas  Ifcellisnotblank Inthisexample,columnDrecordsthedateataskwascompleted.Therefore,ifthecolumncontainsadate(i.e.isnotblank),wecanassumethetaskiscomplete.TheformulaincellE5usestheIFfunctiontocheckifD5is"notempty".Ifso,the... Ifcellisgreaterthan Ifyouwanttodosomethingspecificwhenacellvalueisgreaterthanacertainvalue,youcanusetheIFfunctiontotestthevalue,anddoonethingiftheresultisTRUE,and(optionally)doanotherthingiftheresultofthetestisFALSE.In... Returnblankif ThisformulaisbasedontheIFfunction,configuredwithasimplelogicaltest,avaluetoreturnwhenthetestisTRUE,andavaluetoreturnwhenthetestisFALSE.InplainEnglish:ifValue1equals1,returnValue2.IfValue1isnot1,... Relatedfunctions  ExcelIFFunction TheIFfunctionrunsalogicaltestandreturnsonevalueforaTRUEresult,andanotherforaFALSEresult.Forexample,to"pass"scoresabove70:=IF(A1>70,"Pass","Fail").MorethanoneconditioncanbetestedbynestingIFfunctions.TheIF... ExcelISBLANKFunction TheExcelISBLANKfunctionreturnsTRUEwhenacellisempty,andFALSEwhenacellisnotempty.Forexample,ifA1contains"apple",ISBLANK(A1)returnsFALSE. Relatedvideos  TheIFfunction Inthisvideowe'lllookathowtousetheIFfunction,oneofthemostpowerfulandpopularfunctionsinExcel. Seealso  19tipsfornestedIFformulas ExcelFormulaTraining FormulasarethekeytogettingthingsdoneinExcel. Inthisacceleratedtraining,you'lllearnhowtouseformulastomanipulatetext,workwithdatesandtimes,lookupvalueswithVLOOKUPandINDEX&MATCH,countandsumwithcriteria,dynamicallyrankvalues,andcreatedynamicranges.You'llalsolearnhowtotroubleshoot,traceerrors,andfixproblems.Instantaccess. Seedetails here. 500Formulas| 101Functions Download100+ImportantExcelFunctions Getover100ExcelFunctionsyoushouldknowinonehandyPDF. Email HP Topics FormulaBasics Formula Examples ConditionalFormatting PivotTables ExcelTables ExcelCharts Shortcuts More... Keyfunctions IFfunction VLOOKUP function XLOOKUP function FILTER function SUMIFSfunction COUNTIFSfunction SUMPRODUCTfunction INDEXandMATCH Morefunctions... Hi-I'mDaveBruns,andIrunExceljetwithmywife,Lisa.OurgoalistohelpyouworkfasterinExcel.Wecreate shortvideos,andclearexamplesofformulas,functions,pivottables,conditionalformatting,andcharts. Readmore. Amazingguide.Helpful.Thankyouthankyouthankyou.Mymanystudentsinfinanceallthankyou.-Anisah Excelvideotraining Quick,clean,andtothepoint. Learnmore