IF statements

[Texas10]

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.

[Glenn Kennedy]

Where is the 5% for ICU/Patient lifting on the percentage Tab???? i can see 11.8%, not 5%....

[ChemistB]

I used this formula in Risk Assessment!B5 copied across and down.

=IFERROR(IF(INDEX('Percentage per employee'!$B$5:$P$40, MATCH('Risk Assessment'!$A5,'Percentage per employee'!$A$5:$A$40,0),MATCH('Risk Assessment'!B$4, 'Percentage per employee'!$B$4:$P$4,0))> 0.1, 5,FLOOR(INDEX('Percentage per employee'!$B$5:$P$40, MATCH('Risk Assessment'!$A5,'Percentage per employee'!$A$5:$A$40,0),MATCH('Risk Assessment'!B$4, 'Percentage per employee'!$B$4:$P$4,0)), 0.02)*50),"N/A")

Cells that had an error on "Percent by Emp" result in "N/A" here. Less, than 2% give 0, and so forth.

[Glenn Kennedy]

If the rows & columns are ALWAYS in the same order, use this:
=IFERROR(VLOOKUP('Percentage per employee'!B11,Sheet1!$A$1:$B$6,2,TRUE),"")


If not, use this:

Please Login or Register  to view this content.

To get this to work, I created a LOOKUP table on a hideable sheet.... the version with the simpler formula is attached.

[Texas10]

and it worked! Thanks a lot! I never would have figured it out on my own.

[Glenn Kennedy]

Thanks for the Rep. It's appreciated.