rmtshanker
New member
- Joined
- Sep 30, 2015
- Messages
- 18
- Reaction score
- 0
- Points
- 0
=IF(G4="a",IF(E4=2,45,IF(G4="a",IF(E4=1,13,IF(G4="g",IF(E4=1,19,"0"))))),0)
PAMCO # REP NAME CUSTOMER E/G Year DATE STATUS PAY
PAMCO 1 ROBYN LAWSON John D. Fowler E 1 7/26/2015 A $13.00
PAMCO 2 ROBYN LAWSON Deborah D. Pearson E 2 7/26/2015 A $45.00
PAMCO 3 ROBYN LAWSON Brittany L. Rushing E 1 7/26/2015 A $13.00
PAMCO 4 ROBYN LAWSON Dayern M. Tiemen g 1 7/26/2015 A $13.00
PAMCO 5 ROBYN LAWSON Ebony King E 1 7/26/2015 A $13.00
PAMCO 6 ROBYN LAWSON Darrel J. Hill g 1 7/26/2015 A $13.00
I am not getting G value
PAMCO # REP NAME CUSTOMER E/G Year DATE STATUS PAY
PAMCO 1 ROBYN LAWSON John D. Fowler E 1 7/26/2015 A $13.00
PAMCO 2 ROBYN LAWSON Deborah D. Pearson E 2 7/26/2015 A $45.00
PAMCO 3 ROBYN LAWSON Brittany L. Rushing E 1 7/26/2015 A $13.00
PAMCO 4 ROBYN LAWSON Dayern M. Tiemen g 1 7/26/2015 A $13.00
PAMCO 5 ROBYN LAWSON Ebony King E 1 7/26/2015 A $13.00
PAMCO 6 ROBYN LAWSON Darrel J. Hill g 1 7/26/2015 A $13.00
I am not getting G value