ST Alpha - "STIS: Excel Help/Question" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 156

STIS: Excel Help/Question

Posted by Strongbad (aka Rambler14) Dec 30 '11, 12:27

I have 4 worksheets of rows and rows of data
5th worsheetb is a summary of everything. I've got links to all of the other tabs, so that if I change a number on Sheet 2, it auto-corrects on the Summary Sheet 5. Sheet 5 contains all of the data of Sheets 1-4.

My problem is that with the links, if a field is blank, the Summary tab is treating it as a 0. I don't want it to. I want it to be blank if the value on Sheet 2 is blank. I want it to be 0 if the value on Sheet 2 is 0.

Help?

Responses:

=IF(ISBLANK(A2),"",A2) -- nm - JaxSean Dec 30, 12:31 1
- Ah. Graci. -- nm - Strongbad Dec 30, 12:34

Post a message top

STIS: Excel Help/Question

Replies are disabled on threads older than 7 days.