Only perform calculation if cell is not blank

mattbarnaby108576

I have search the community and tried some stuff but have had no luck, pretty sure it is an easy fix. I have "todays" percentage cell subtracted from the previous day.  however it is also calculating " tomorrows" date even though there is no data in the field.  How can i have it calculate only when data is in the cell.

 

Mike Wilday

What formula are you using? 

You can integrate it into this IF statement... 

IF(ISBLANK(Percentage@row), "", INSERT YOUR FORMULA HERE)

This will return a blank cell if there is no percentage data.