Need help w very difficult formula!

[Kelly Jo Lyth]

Hello all!
I need help with an "if then" formula.
What I have is a list of about 8000 people in column a,
their hours worked in column b, and a number of
8,9,10,11,12,13,20,21,22,23 in column c. I need several
things to happen. If someone's scheduled hours worked are
greater than or equal to 32, and they are 8,9,10 I need a
result to say 150. If someone's scheduled hours are less
than 32 and they are 8,9,10, I need the result to say 75.
AND If their hours are greater than or equal to 32, and
they are 12 or 13, the result = 250, if hours less than 32
and 12 or 13, 125 AND If they are scheduled greater than
or equal to 32, and 20,21,22,23 the result = 300, if hours
less than 32 and 20,21,22,23 the result = 150.

If anyone has input you will save my sanity!!!!! Thanks in
advance for any help!!!

Kelly : )

 

[Bob Phillips]

Hi Kelly Jo,

One way

=IF(OR(B1=8,B1=9,B1=10),IF(A1>=32,150,75),IF(OR(B1=12,B1=13),IF(A1>=32,250,1
25),IF(A1>=32,300,150)))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Trevor Shuttleworth]

Kelly Jo

One way:

=IF(hours>=32, IF(OR(code=8,code=9,code=10),150,
IF(OR(code=11,code=12,code=13),250,
IF(OR(code=20,code=21,code=22,code=23),300))),
IF(OR(code=8,code=9,code=10),75, IF(OR(code=11,code=12,code=13),125,
IF(OR(code=20,code=21,code=22,code=23),150))))

Where, for the sake of argument, column B is named as "hours" and column C
is named as "code"

Regards

Trevor