I am trying to create an IF statement that if cell c5 and d5 are blank then the result will be a blank cell, if it one of them has a value then a formula will be the result. So far i have been trying this with no luck =IF(ISBLANK(C5:D5),"",E4+C5-D5) the formula will work but when i autofill the formula to lower cells and remove a value in say c7 and d7 it shows the carrying value from above instead of a blank cell.