MrExcel Publishing
Your One Stop for Excel Tips & Solutions

ISBLANK Formula


Posted by Val Espinoze on May 01, 2000 2:58 PM

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 Celia on May 01, 2000 3:10 PM


Val
Can't follow what you are trying to do.
How are the totals being entered down the column?
What should be blank when a total is not wanted?
Celia