Why register? ...To Enhance Your Experience
+ Reply to Thread
Results 1 to 9 of 9
  1. #1
    Forum Member
    Join Date
    May 2004
    Location
    Eastern Central Kansas
    Posts
    845

    Default For the computer whizes

    I am trying to make excel work.

    I am trying to write a formula. This is what I am trying to do.

    If the value in cell D2 is 0 hide row 2, if the value is greater than 0 do not hide row 2.
    FF I
    FF II
    Hazmat Operations
    EMT-B
    ---------------------------------------------------

    The light at the end of the tunnel has been temporarly shut off due to the current work load. The Mangement

    When all else fails USE DUCT-TAPE!!!

    My views posted in this fourm are my personal views only and do not reflect on any agencies that I am afiliated with.


  2. #2
    Forum Member Skwerl530's Avatar
    Join Date
    Dec 2003
    Location
    TN
    Posts
    232

    Default

    Hmmm This may work for you:
    =IF(D2>0, D2, " ")

    It prints the value listed in D2 if it is greater than 0. If it is less than 0 it just prints a space ( " " ). I'm not sure if you can hide an entire row.
    We struck down evil with the mighty sword of teamwork and the hammer of not bickering.

  3. #3
    Forum Member
    Join Date
    May 2004
    Location
    Eastern Central Kansas
    Posts
    845

    Default

    I bet that what I am trying to do is not supported by microsoft. Even the microsoft support people are going, WTF?
    FF I
    FF II
    Hazmat Operations
    EMT-B
    ---------------------------------------------------

    The light at the end of the tunnel has been temporarly shut off due to the current work load. The Mangement

    When all else fails USE DUCT-TAPE!!!

    My views posted in this fourm are my personal views only and do not reflect on any agencies that I am afiliated with.

  4. #4
    MembersZone Subscriber tyler101's Avatar
    Join Date
    Feb 2002
    Location
    Ashland, OH
    Posts
    471

    Default

    =if((a2-b2)<0,0,a2-b2)

  5. #5
    Forum Member Skwerl530's Avatar
    Join Date
    Dec 2003
    Location
    TN
    Posts
    232

    Default

    Maybe we need a little more info if none of the above worked
    We struck down evil with the mighty sword of teamwork and the hammer of not bickering.

  6. #6
    Forum Member
    Join Date
    May 2004
    Location
    Eastern Central Kansas
    Posts
    845

    Default

    I sent a email to someone I know that is a computer programer, He says that excell wont support a formula like that. Darn!
    FF I
    FF II
    Hazmat Operations
    EMT-B
    ---------------------------------------------------

    The light at the end of the tunnel has been temporarly shut off due to the current work load. The Mangement

    When all else fails USE DUCT-TAPE!!!

    My views posted in this fourm are my personal views only and do not reflect on any agencies that I am afiliated with.

  7. #7
    Forum Member Dave1983's Avatar
    Join Date
    Oct 2003
    Location
    Gator Country
    Posts
    4,157

    Default

    E=mc2
    Fire Marshal/Safety Officer

    IAAI-NFPA-IAFC/VCOS-Retired IAFF

    "No his mind is not for rent, to any god or government"
    RUSH-Tom Sawyer

    Success is when skill meets opportunity
    Failure is when fantasy meets reality

  8. #8
    Forum Member SafetyPro's Avatar
    Join Date
    Dec 2003
    Location
    Santa Cruz, CA
    Posts
    486

    Default

    Are you trying to "hide" the row (make it disappear altogether), or just give it blank values?

    I'm fairly handy with Excel...if you want to e-mail it to me and explain what you want to do, I'd be happy to take a look at it.

    Chris
    Chris Gaylord
    Emergency Planner / Fire Captain, UC Santa Cruz FD

  9. #9
    FH Mag/.com Contributor
    Join Date
    Feb 2002
    Location
    Cypress, TX
    Posts
    7,288

    Default

    Sounds like hide the row. Not sure why you'd want that, but hey, that's why there's chocolate and vanilla.

    Anywho, you're going to have to hit Tools, Macros, and Visual Basic Editor and code yourself a function to key off of the value in that cell/row changing, and if it's 0 or empty, then change the row height to 0 also. Of course, you'll need to change it back to something other than 0 in height if there is something you want to see.

    Welcome to my world, Visual Basic Programming. Of course I avoid automating or programming MS applications like what you're doing at all costs, but it's still the same programming language and functions.

    If I can throw enough work product at other people in the next hour or so I'll figure it out and post it if someone doesn't beat me to it.

    - Brian
    Brian P. Vickers
    www.vickersconsultingservices.com
    Emergency Services Consulting
    Westlake VFD - Houston, TX
    Proud Member IACOJ - Redneck Division

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Fire Chief in North Naples Florida Under Fire
    By captstanm1 in forum The Off Duty Forums
    Replies: 65
    Last Post: 10-12-2006, 09:56 PM
  2. ABBOTT and COSTELLO Buy A Computer
    By MalahatTwo7 in forum The Off Duty Forums
    Replies: 6
    Last Post: 03-14-2005, 07:50 PM
  3. ABBOTT and COSTELLO Buy A Computer
    By MalahatTwo7 in forum The Off Duty Forums
    Replies: 2
    Last Post: 08-04-2004, 12:52 PM
  4. When's the last time you did computer clean-up? Spyware beware!
    By CCVFD952 in forum The Off Duty Forums
    Replies: 3
    Last Post: 10-09-2003, 08:44 AM
  5. Replies: 1
    Last Post: 10-30-1999, 12:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts