How to not calculate (ignore formula) if cell is blank in Excel?
Let's 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.
To ignore a formula or don't calculate if the specific cell is blank in Excel, we need to check the specific cell is blank or not with IF function, if it's 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()-B2)/365.25,"") into Cell C2, and then drag the Fill Handle to the range you need.
|Formula is too complicated to remember? Save the formula as an Auto Text entry for reusing with only one click in future!
Read more… Free trial
Note: The B2 means Cell B2 filled with birthday, if the Cell B2 is blank it will ignore the formula and return blank, if the Cell B2 is filled with birthday, it will return the age.
Alternatively, we can also combine the IF function and original formula as =IF(Specific Cell="","","Original Formula"), and in our case the formula is shown as =IF(B2="","",(TODAY()-B2)/365.25).