I need formula

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
 
Following your later illustration, my attachment starts with "E/G" data in Col A. As is, no records have STATUS = "g", so the G Values can't be returned.
See my attachment for a solution. For the record, it would be much simpler to include some AND/OR functions but as is, its a good illustration of the effective use of brackets in getting the formula to work correctly.
 

Attachments

  • Copy of if formula1.xlsx
    9.5 KB · Views: 9
Back
Top