K
Karen Smith
I have 2 formulas that I need to add another condition to and everytime I try
it, it doesn't work. Both formulas also need to say: If 'The Worker
Be!'!B8=CD then do nothing with the formulas below.
Formula 1:
=IF(AND($S8="A.",'The Worker Be!'!$G8="New"),$B$2*'The Worker
Be!'!$F8,0)+IF(AND($S8="A.",'The Worker Be!'!$G8="Update"),$B$3*'The Worker
Be!'!$F8,0)+IF(AND($S8="B.",'The Worker Be!'!$G8="New"),$B$2*'The Worker
Be!'!$F8,0)+IF(AND($S8="B.",'The Worker Be!'!$G8="Update"),B3*'The Worker
Be!'!$F8,0)+IF(AND($S8="C.",'The Worker Be!'!$G8="New"),$B$5*'The Worker
Be!'!$F8,0)+IF(AND($S8="C.",'The Worker Be!'!$G8="Update"),$B$5*'The Worker
Be!'!$F8,0)+IF(AND($S8="D.",'The Worker Be!'!$G8="New"),$B$4*'The Worker
Be!'!$F8,0)+IF(AND($S8="D.",'The Worker Be!'!$G8="Update"),$B$4*'The Worker
Be!'!$F8,0)
Formula 2:
=IF(AND(S8="A.",'The Worker Be!'!K8="X"),$D$3*'The Worker
Be!'!$F8,0)+IF(AND(S8="B.",'The Worker Be!'!K$8="X"),$D$3*'The Worker
Be!'!$F8,0)+IF(AND(S8="C.",'The Worker Be!'!$K8="X"),$D$4*'The Worker
Be!'!$F8,0)+IF(AND(S8="D.",'The Worker Be!'!$K8="X"),$D$3*'The Worker
Be!'!$F8,0)
Any one have any ideas? Thanks in advance for your help.
it, it doesn't work. Both formulas also need to say: If 'The Worker
Be!'!B8=CD then do nothing with the formulas below.
Formula 1:
=IF(AND($S8="A.",'The Worker Be!'!$G8="New"),$B$2*'The Worker
Be!'!$F8,0)+IF(AND($S8="A.",'The Worker Be!'!$G8="Update"),$B$3*'The Worker
Be!'!$F8,0)+IF(AND($S8="B.",'The Worker Be!'!$G8="New"),$B$2*'The Worker
Be!'!$F8,0)+IF(AND($S8="B.",'The Worker Be!'!$G8="Update"),B3*'The Worker
Be!'!$F8,0)+IF(AND($S8="C.",'The Worker Be!'!$G8="New"),$B$5*'The Worker
Be!'!$F8,0)+IF(AND($S8="C.",'The Worker Be!'!$G8="Update"),$B$5*'The Worker
Be!'!$F8,0)+IF(AND($S8="D.",'The Worker Be!'!$G8="New"),$B$4*'The Worker
Be!'!$F8,0)+IF(AND($S8="D.",'The Worker Be!'!$G8="Update"),$B$4*'The Worker
Be!'!$F8,0)
Formula 2:
=IF(AND(S8="A.",'The Worker Be!'!K8="X"),$D$3*'The Worker
Be!'!$F8,0)+IF(AND(S8="B.",'The Worker Be!'!K$8="X"),$D$3*'The Worker
Be!'!$F8,0)+IF(AND(S8="C.",'The Worker Be!'!$K8="X"),$D$4*'The Worker
Be!'!$F8,0)+IF(AND(S8="D.",'The Worker Be!'!$K8="X"),$D$3*'The Worker
Be!'!$F8,0)
Any one have any ideas? Thanks in advance for your help.