Multiple functions

[Guest]

I need to return a True or False Value in Columns G and H Using the data in
columns A through F. Below is an example of the data I am working with:

A B C D E F
G H
6 1.50 1000 128.30 1000 75.7 Help Award
7 Joe 0.00 0.00 0.00 0.00 0
8 James 5.45 1190 91.54 330 58.93
9 Jay 0.00 530 96.36 5544 69.96 10 Jack 1.21 9833 103.23 408 65.28
11 Jan 0.60 0 0.00 7633 65.38
12 Jane 1.18 3879 111.63 4591 62.68


I need Column G to indicate an employee needs "Help" (Jack as example)
B10>B6*.90 OR, C10>C6 AND D10<D6*.90 OR, E10>E6 AND F10<F6*.90
If ANY of these are true, then the employee needs help

I need Column H to indicate that an emplyee gets and "Award" if they are
=or< 1 in Column B, have =or> 1000 in Column C AND =or> 128.3 in Column D
OR have =or> 1000 in Column E AND =or> 75.7 in Column F
So employees must have 1 or less in Column B (first step) AND 1000 or over
at a rate of 128.3 or Greater OR 1000 at a rate of 75.7 or Greater (second
step).

Thanks in advance for your help

 

[Guest]

Sorry,...Worksheet should look like this:

I need to return a True or False Value in Columns G and H Using the data in
columns A through F. Below is an example of the data I am working with:

A B C D E F G H

6 1.50 1000 128.30 1000 75.7 Help Award
7 Joe 0.00 0.00 0.00 0.00 0
8 James 5.45 1190 91.54 330 58.93
9 Jay 0.00 530 96.36 5544 69.96 >10 Jack 1.21 9833 103.23 408 65.28
11 Jan 0.60 0 0.00 7633 65.38
12 Jane 1.18 3879 111.63 4591 62.68


I need Column G to indicate an employee needs "Help" (Jack as example)
B10>B6*.90 OR, C10>C6 AND D10<D6*.90 OR, E10>E6 AND F10<F6*.90
If ANY of these are true, then the employee needs help

I need Column H to indicate that an emplyee gets and "Award" if they are
=or< 1 in Column B, have =or> 1000 in Column C AND =or> 128.3 in Column D
OR have =or> 1000 in Column E AND =or> 75.7 in Column F
So employees must have 1 or less in Column B (first step) AND 1000 or over
at a rate of 128.3 or Greater OR 1000 at a rate of 75.7 or Greater (second
step).

Thanks in advance for your help

 

[Roger Govier]

Hi

Depending upon what you mean when you say ANY of these are True.
If that is literally what you mean then

=IF(OR(B10>B6*.90,
C10>C6,
D10<D6*.90,
E10>E6,
F10<F6*.90),"Help","")

But reading your AND's and OR's as you have them set out, perhaps you
mean

=IF(AND(
OR(B10>B6*.90,C10>C6),
OR(E10>E6,F10<F6*.90),
D10<D6*.90 ),"Help","")

For the second part of your question

=IF(B1>1,"",
IF(AND(C1>=1000,D1>=128.3),"Award",
IF(AND(E1>=1000,F1>=75.7),"Award","")))