Hi there
In worksheet there are two text that require a different rate
Cell A1 Trustee Fee March 2021 - IN0000
Cell B1 Bell Projects Costs Dec 23 (Fam) - IN000A
The words in Cell A1‘Trustee Fee ‘ and words in Cell B1 ‘Bell Project Cost (Fam)’ will be recurring text each month . I mind to know how I can create a wildcard with in a IF function to capture their rate
If (or(a1 =“*Trustee Fee*”, b1=“*Bell Project Cost (Fam)*”), 0.02, 0.04)
On evaluation of formula , gives me false as cell a1 is not exactly equal to “Trustee Fee” for example . How can I fix the formula ?
Thank you
In worksheet there are two text that require a different rate
Cell A1 Trustee Fee March 2021 - IN0000
Cell B1 Bell Projects Costs Dec 23 (Fam) - IN000A
The words in Cell A1‘Trustee Fee ‘ and words in Cell B1 ‘Bell Project Cost (Fam)’ will be recurring text each month . I mind to know how I can create a wildcard with in a IF function to capture their rate
If (or(a1 =“*Trustee Fee*”, b1=“*Bell Project Cost (Fam)*”), 0.02, 0.04)
On evaluation of formula , gives me false as cell a1 is not exactly equal to “Trustee Fee” for example . How can I fix the formula ?
Thank you