Multiple functions
 

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)
B10B6*.90 OR, C10C6 AND D10<D6*.90 OR, E10E6 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

Multiple functions
 

Sorry,...Worksheet should look like this:



"kjguillermo" wrote:

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)
B10B6*.90 OR, C10C6 AND D10<D6*.90 OR, E10E6 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



"kjguillermo" wrote:

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)
B10B6*.90 OR, C10C6 AND D10<D6*.90 OR, E10E6 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

Multiple functions
 

Hi

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

=IF(OR(B10B6*.90,
C10C6,
D10<D6*.90,
E10E6,
F10<F6*.90),"Help","")

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

=IF(AND(
OR(B10B6*.90,C10C6),
OR(E10E6,F10<F6*.90),
D10<D6*.90 ),"Help","")

For the second part of your question

=IF(B11,"",
IF(AND(C1=1000,D1=128.3),"Award",
IF(AND(E1=1000,F1=75.7),"Award","")))

--
Regards

Roger Govier


"kjguillermo" wrote in message
...
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)
B10B6*.90 OR, C10C6 AND D10<D6*.90 OR, E10E6 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