如果單元格在Excel中為空,如何不計算(忽略公式)? | excel if空白
Howtonotcalculate(ignoreformula)ifcellisblankinExcel?LetssaywehavearollofstudentswiththeirbirthdaysinExcel,andwearerequiredtocalculatestudentsage.Normallywecanapplytheformulaof=(TODAY()-B2)/365.25tofigureouttheages.However,wegetridiculousagesbecausesomestudentsbirthdaysarenotfilledbyaccident.Topreventtheerrors,wehavetonotcalculateorignoretheformulaifcellsareblankinExcel.Donotcalculate(ignoreformula)ifcellisblankinExcel[1]DonotcalculateorignoreformulaifcellisblankinExcelToignoreaformulaordont...
How to not calculate (ignore formula) if cell is blank in Excel?Lets say we have a roll of students with their birthdays in Excel, and we are required to calculate students age. Normally we can apply the formula of =(TODAY()-B2)/365.25 to figure out the ages. However, we get ridiculous ages because some students birthdays are not filled by accident. To prevent the errors, we have to not calculate or ignore the formula if cells are blank in Excel.
Do not calculate (ignore formula) if cell is blank in Excel[1]
Do not calculate or ignore formula if cell is blank in ExcelTo ignore a formula or dont calculate if the specific cell is blank in Excel, we need to check the specific cell is blank or not with IF function, if its not blank, we can go ahead to calculate with original formula.
=IF(Specific Cell<>"",Original Formula,"")
In our case discussed at the beginning, we need to enter =IF(B2<>"",(TODAY(...