Results 1 to 6 of 6

IF statements

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    Dallas,Texas
    MS-Off Ver
    Excel 2003
    Posts
    20

    IF statements

    I posted this under another section but I think you could write an If function to do the same thing. I've been working on it and have progressed a little, but still cant hone it in.

    Good morning,

    I'm working on a safety database where I'm tracking work place injuries (see attachment). I'm taking the number of injuries that occur (in the injuries tab) and dividing by the number of employees (employees tab) to give me a percentage of employees injured for that specific area (percentage tab). What I'm looking for however, is a code that will automatically take those percentages and inputs the appropriate number on the first tab (risk assessment) according to the key listed at the bottom of the risk assessment tab. For example, if the ICU had 5% of its employees injured due to patient lifting on the percentage tab, I want the cell under patient lifting to automatically populate with a 2 in the risk assessment tab.

    Hope that is as clear as mud.

    As always, any help is greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula with multiple IF statements and IF AND statements
    By lottidotti in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-14-2013, 08:03 AM
  2. Reading If statements and formulating values from if statements
    By crnam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 05:20 AM
  3. questions with if statements and nested if statements
    By Pat Excel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-03-2013, 01:41 PM
  4. Multiple nested IF statements and AND statements
    By TonyGetz in forum Excel General
    Replies: 2
    Last Post: 12-14-2010, 03:07 AM
  5. Nested If statements / logic statements
    By Brainless_09 in forum Excel General
    Replies: 3
    Last Post: 06-17-2009, 02:59 PM
  6. Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  7. operator statements, shorting when reusing one of the statements?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2005, 02:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1