Hello everyone,
I'd like to know how can I hide a sheet, just in case a given cell is 0 (cero). I know how to hide a sheet always (A1: Auto+Hide+HideSheet), but I want to establish that condition.
My file reports the same aspects for different companies of the group, and I want to show only the companies whose sum is different to 0 (cero).
Thank you in advance!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello again,
I just discovered how to do it!!
_________1______________2_________
A____Auto+Hide________Hide+?
B_______Hide+?___=if(C4=0;"HideSheet")
Where C4 is the given cell, the one that determins the total sum
Thank You
Please sign in to leave a comment.