MrExcel Publishing
Your One Stop for Excel Tips & Solutions

ISBLANK formula

Posted by Val Espinoza on April 27, 2000 9:21 AM

Can you give me the formula to stop "totals" from repeating? Example I have a total in E2, which calculates the following: e1+c2-b2. However, I don't want the totals to repeat themselves all the way down the column. I know you have to use"ISBLANK" but it just won't work for me. Can you help with the correct formula? THANKS!

Posted by Val Espinoza on May 01, 2000 10:18 AM