Nested IF statement with AND

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

I need a formula that will return one of two answers under
three conditions. We have a system of codes that I must
match to return the correct time in payroll. Example: If
the person used the code ME001, and posted "event" the
time as REGULAR, and had an activity code for the job
they are working on of Q023, return the time spent, if not
return a Zero.

The spreadsheet has the time spent in C11, code in cell
F11, event code is in G11, and Job code in H11 (or a zero
if there is no Job code. I have tried many combinations
but can't get the result I need, (either the time from
cell C11 or a zero). I have daily sheets for Sunday-
Saturday am working on a summary spreadsheet
called "Calculations" with the labels for the Code in
D5,Event code in F2. the Tried many different parenthesis
and zero combinations but none work correctly--currently
have:
=IF(Sunday!$G11=$F$2,(IF(AND(Sunday!$F11=D$5,(IF(AND
(Sunday!$H11>0),Sunday!$C11))),0,0)))
 
Jean

I think this is what you are chasing.

=IF(AND(Sunday!$G11=$F$2,Sunday!$F11=D$5,Sunday!
$H11>0,Sunday!$C11),C11,0)

Tony
 
Back
Top