I am having issues getting a formula to work. The objective is to get a percentage to show on B only if there is data entered into D and E. I was attempting to do so with IF. The first issue is that I cant get it to rely on both cells being blank it will only work if one is. I believe this can be cured with nested IF but have not tried yet. If it is not possible I can work with the formula relying on D as the blank cell. The second most major issue is that the cell is automatically going to the equation and showing 100% when the input cells are blank. The Formula used is this: =IF(D10=" ","(636-((D11*12)+E11))/636"," ")