This statement works fine:
=IF(MID(F28,5,2)="PR",G28,IF(MID(F28,5,2)="PF",G28,0))
But I needed to add some extra checks so I wrote this:
=IF(MID(F28,5,2)="PR",G28,IF(MID(F28,5,2)="PF",G28,if(mid(f28,4,2)=”PR”,g28,if(mid(f28,4,2)=”PF”,g28,0))))
But now I get the #Name? error.
Any idea why?
I'm trying to find entries that have a .PF or .PR in them:
ie.
return true for BMO.PR.L
return true for BMO.PF.C
return true for BAM.PR.T
return true for CM.PR.O
return false for ENB
return false for DRA.UN
return false for DH.DB
the additional formula was to catch the CM.PR.O as the first formula did not recognize this as being true as it was looking at the wrong 2 characters (with my formula it would see 'R.' instead of the 'PR').
Thanks,
=IF(MID(F28,5,2)="PR",G28,IF(MID(F28,5,2)="PF",G28,0))
But I needed to add some extra checks so I wrote this:
=IF(MID(F28,5,2)="PR",G28,IF(MID(F28,5,2)="PF",G28,if(mid(f28,4,2)=”PR”,g28,if(mid(f28,4,2)=”PF”,g28,0))))
But now I get the #Name? error.
Any idea why?
I'm trying to find entries that have a .PF or .PR in them:
ie.
return true for BMO.PR.L
return true for BMO.PF.C
return true for BAM.PR.T
return true for CM.PR.O
return false for ENB
return false for DRA.UN
return false for DH.DB
the additional formula was to catch the CM.PR.O as the first formula did not recognize this as being true as it was looking at the wrong 2 characters (with my formula it would see 'R.' instead of the 'PR').
Thanks,