I have an If statement and I want it to pull in data based on whether there is a G or an 8
Here is the formula now.
=IF(LEFT($F589,1)="8",IF($A589=PRVME,ROUND($I589*PEOM,2),ROUND($I589*DECK,2)),+$I589)
The first part, IFIF(LEFT($F589,1)="8", I want it to look for the "8" and also the "G" in the data. How do I write this part?
Thanks
Here is the formula now.
=IF(LEFT($F589,1)="8",IF($A589=PRVME,ROUND($I589*PEOM,2),ROUND($I589*DECK,2)),+$I589)
The first part, IFIF(LEFT($F589,1)="8", I want it to look for the "8" and also the "G" in the data. How do I write this part?
Thanks