Hello,

I have a cell (J9) that could be one of 5 scenarios:

# = any possible number

WAC + #%

WAC - #%

AWP + #%

AWP - #%

ACQ + #%

I keep trying to figure out a formula that'll format all five of these into cell N9 based on the data in J9.

These would look like:

WACRB+##.00

WACRB-##.00

AWP*B+##.00

AWP*B-##.00

ACQ**+##.00

Here's an example of what I have thus far, but it limits me to only three scenarios and I keep getting "Too Many Arguments" when I attempt to add the other two:

=IF(J9="","- No Rate -",IF(LEFT(J9,3)="ACQ","ACQ**+"&TEXT(MID(J9,FIND("+ ",J9)+2,FIND("%",J9)-FIND("+",J9)-2),"00.00"),IF(LEFT(J9,3)="WAC","WACRB+"&TEXT(MID(J9,FIND("+ ",J9)+2,FIND("%",J9)-FIND("+",J9)-2),"00.00"),"AWP*B-"&TEXT(MID(J9,FIND("- ",J9)+2,FIND("%",J9)-FIND("-",J9)-2),"00.00"))))

Assistance, please. Thank You.