----- Original Message -----
From: "Allen" <[email protected]>
To: <[email protected]>
Sent: Saturday, January 30, 2010 6:58 PM
Subject: [users] Calc conditional question
Hi gang,
Is there any way to make a formula conditional depending on
whether the cells in the row referred to are visible or hidden.
What I need to do is create a summary of the sub-sections of a
standard so executives can see the overall but then also have the
detailed view available but not have the summary figures shown.
It would look approximately like this in summary mode:
ISO 27002-10 (Title) 5 8 1 3 6
each column would refer to an areas examined in a security
assessment.
Then the expanded version would look like this approx:
ISO 27002-10 (Title)
ISO 27002-10.1 1 0 0 0 1
ISO 27002-10.2 0 2 1 0 0
ISO 27002-10.3 2 0 0 1 0
ISO 27002-10.4 0 0 0 1 3
ISO 27002-10.5 1 5 0 0 1
ISO 27002-10.6 1 1 0 1 1
So those who want a more granular view can get it by just
unhiding the rows but the totals at the chapter level would go
away to prevent reading the data as though there were more
instances than reality because people tend to sum what they see
in a glance rather than realizing that one is a summary line only.
If this is not possible - the client *really* wants this layout -
I would guess the best way is to do two sheets with one the
summary view that references the correct cells in the second,
more granular sheet, right?
Thanks,
Allen
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
