For my formula, I would like for it to not display the information in one column if the other column is zero.
I am trying to figure out that if G9 is zero then dont display the information in I9, and vice versa. ( if the number in G9 is greater than zero then display the information in I9 .
Maybe something like...
=if(G7=0,"",I9)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks